At 21:51 4-2-2003, you wrote:
* if the update does not have anything to work on it does not mean it is a failure! except when you EXPECTED it to update something.hi.. posted a message about what the code was to test an update query to see if it was successfull using mysql and i tested my code and for some reason even if none of the fields were updated it still reports the success message...heres the code i have: $query=mysql_query("update members set company="\$company\", ........); if($query){ message if successfull... } else{ message if not or if failed..//never gets used } anybody know why this doesnt work if 0 records were changed?
* i'm not sure whether "if ($query) " is the proper way to check this.
for trapping development errors i always suggest:
$q="update members set company="\$company\", ........
$query=mysql_query($q) or
die ('<hr>DB update failed in '.__FILE__.' line '.__LINE__.'<br>Query was:'.$q.'<br>mysql reported:'.mysql_error());
* for counting the affected rows use
http://nl.php.net/manual/nl/function.mysql-affected-rows.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
