Page 1 of 1

find out about update results

Posted: Wed Apr 27, 2005 1:15 pm
by Burrito
Know this has been answered before do I. In a huge hurry I am.

need to know how to determine if an update query updated any results I do.

ex:

Code: Select all

$isupdate = mysql_query("update myTable set myField = 1 where myOtherField = 'me'");
sorry to ask this question am I, but in a huge hurry I am....

Burrito

Posted: Wed Apr 27, 2005 2:04 pm
by shiznatix
mysql_effected_rows its either that or somthing similar, it will return how many rows were effected by the query

Posted: Thu Apr 28, 2005 3:06 am
by n00b Saibot