I am getting mad here! I don't know why this stuff just don't work.
I am trying to update this table. When I set the condition to UserID which is the primary key, it does not change it and it returns this message even if I supply an existing UserID:
Query OK, 0 rows affected
Rows matched: 0 Changed: 0 Warnings: 0
If The condition was something else like Surname, Email...etc, it works fine.
The primay key (UserID) is auto_increment!
mysql> UPDATE PersonalDetails SET Initials="Miss", Surname="Something", Forename="Maja", Address="01 Co", PostCode="212", TelHome="21", TelMobile="121", Email="email@example.com" WHERE UserID=14;
Thanks very much in advance.