|
|
Posted by Gordon Burditt on 01/31/06 18:48
>What's the best practice for handling the following situation, when I
>do an update like this:
>
>$sql = "UPDATE haha SET papa="loco" WHERE id=$var";
>$res = mysql_query($sql,$db);
>
>If I don't get a match in my where clause, i.e., 12!=44 the UPDATE does
>not occur but mysql_errno == 0 and mysql_error = "" so I can't capture
>the failure.
It's NOT a failure. The query did what you wanted it to.
From an application point of view, sometimes affecting or
retrieving any rows is a failure (consider black lists).
I believe you can look at mysql_affected_rows() and see how many
rows it changed.
Gordon L. Burditt
Navigation:
[Reply to this message]
|