Update records in MYSQL

[Edje]

Hi,

I'm experiencing some problems with updating multiple records in a mysql table.

I'm looping thru some code in php and during every loop I execute an update statement which every time updates a single record in my table. But it seems that not all the records which should be updated are actually updated after the loop.

So far I've echoed all my queries I've generated and executed during the loop statement. I've executed these queries one by one in the mysql GUI which I'm using which is mysqlman, and all these queries give the expected result. I've also printed the mysql_affected_rows after each query and again these values are correct, but still when I browse the table in which I've updated the records the data is incorrect. Further more there have been no mysql_errors during the execution.

Is this voodoo or what ?

Eddy

[ultraslacker]

Code?

[erick_w]

We need to see your code... if you have the mysql_affected_rows after each query, we can assume that your connection runs well. All you have to do is check your SQL queries for UPDATE statement, something like this:

$sql=mysql_query("UPDATE table_name SET data1='$data1',data2='$data2', ...... WHERE Condition....");

don't forget WHERE statement, it's important to update a specific query unless you will update the all rows in the table. 🙂

Hope it helps! 🙂