On Monday 24 June 2002 13:03, David Robley wrote:
> In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
> > I can't get UPDATE to work properly when querying MySQL.
> > $query = "UPDATE $table SET field1='$var1' WHERE id='$id'";
> > I want to update one field of one row in a table. Is this syntax
> > correct?
> if id is an int type, no. You only need to quote values being passed to
> [var]char or text type fields.
I don't know whether it is 'correct', but it works with or without quotes. For
consistency I would use the quotes.
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
It's easier to take it apart than to put it back together.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php