I think the update commands with three column update should work fine. But you can check what are the values you are supplying, what are the table column data type, check are you sending null values or not, you may need to convert data to the right type.
Try to print the query with
echo $query_string_variable
Then execute the query in the database by itself [not from PHP [I mean in mysql console/GUI/Mysql Browser/PhpMyAdmin].
] and see if it runs or what kind of errors it provides
You can also try the other way....try to write a query by providing static values and run the query into the database. if the query runs take it and use variables to provide the values. See what it does. Also, print these query and execute in the backend database [I mean in mysql console/GUI/Mysql Browser/PhpMyAdmin].
Strange! Now, execute this query in mysql console or phpmyadmin. If it still doesn't update, check the column datatype. 
I don't see any problem with the query.
Well, i tried running the query using the MySQL GUI (NaviCAT) wioth static data. Again, the same problem arises. The query runs perfectly well for 'dod' and 'yod', but when i run it for 'mod', it shows the error,
You have an error in your SQL syntax, check the manuala that corresponds to your MySQL server version for the right syntax to use near 'mod = '12' where ID = '1" at line 1
PS... The query i used was :=- UPDATE client SET mod = '12' where ID = '1'
with
exactly the shown usage of (' '), but the error shows a certain different type of usage.
PS2-- I have also tried using 'text' for the defintion of the 3 columns in the table, and hav even tried int(the 3 cols are basically for date, month and year)... but both produce the same results.
somebody pls suggest sumthing... this is getting really fustrating...
thx nav33 and sayedjustetc for your time n effort. 
Offline 
Unsolved 
