Other than that, this My SQL database table is relatively normal, though it is greatly simplified.

Given that My SQL database table design, let's assume that we just want to update one record in this table.

Try to print the query with echo $query_string_variable Then execute the query in the database by itself [not from PHP You can also try the other way...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. Also, print these query and execute in the backend database I think the update commands with three column update should work fine.

All source code included in the card How to update a My SQL column with ascending numbers is licensed under the license stated below.

To do so, we just need to follow these steps: I've tried to document the following Java My SQL UPDATE example so you can see these steps.

Note that in this example my My SQL database username is "root", my password is blank, and the My SQL database is running on the same computer where this program is run, so the database host name is "localhost". * Demonstrates the use of a SQL UPDATE statement against a * My SQL database, called from a Java program.

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 You can also try the other way...to write a query by providing static values and run the query into the database. Why are you using single quotes around the variables in your queries?