Re: Re: UPDATE mysql

On Monday 24 June 2002 13:03, David Robley wrote: > In article <sd148e91.085@cis27.hosts.jhmi.edu>, pschwar@jhmi.edu 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. -- Washlesky */