Hello,
I am trying to perform 2 UPDATEs from the same mysql_query statement. The query is:
When, i run this query frm mysql_query, i notice later that the UPDATEs did not take place. The funny thing is that these statement work, if i separate them. What's more, the combined query works as required, when i run it from phpMyAdmin.
Any clues? Perhaps the string is not well formed or something? I am not getting any error.
The code I am using is as below:
$sql="UPDATE projects SET accepted=1 WHERE id=10;UPDATE bids SET has_won=1 WHERE id=3";
mysql_query($sql);
Thank You.
Saurabh Kumar
