mysql_error on an update

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.

Any thoughts?

Jeff

.

Relevant Pages

  • Re: mysql_error on an update
    ... >What's the best practice for handling the following situation, ... It's NOT a failure. ... Prev by Date: ...
    (comp.lang.php)
  • Re: perl to fortran thoughts
    ... that it's not good practice at their end to be handling the input in this ... to be handling the input in this way. ... As far as my complaint and Greger's response goes, ... am a stickler for the abolutes of best practices first and the discernment ...
    (comp.lang.perl.misc)
  • Re: home defense recommendations
    ... following all of the rules of safe gun handling. ... Then you probably shouldn't have a gun at all. ... A gun you never practice handling is nothing but a BIGGER PROBLEM. ...
    (rec.guns)
  • Re: Spins
    ... Well, al of that is very true, but the foundation of good aircraft ... handling is still central in my view. ... seems to indicate that training and practice is deficient in ... his checks and then changed to the fullest tank. ...
    (rec.aviation.piloting)
  • com interop C# GUI thread
    ... I am currently calling a windows form from my vb6 app. ... best practice ... for handling the gui thread. ...
    (microsoft.public.dotnet.framework.interop)