Posted by Jim Michaels on 02/11/06 23:38

"Jeff" <joesiege@gmail.com> wrote in message
news:1138722255.036505.213460@f14g2000cwb.googlegroups.com...
> 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);

Why are you not escaping your \" quotes around loco?

>
> 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
>

[Back to original message]