Re: [PHP] mysql update help needed

2002-03-20 Thread Miguel Cruz
On Wed, 20 Mar 2002, ROBERT MCPEAK wrote: > $sql = "UPDATE mytable SET > img_url=$img_url,visitdate=$visitdate,img_group=$img_group,display=$display, > caption=$caption where id = $id"; You need to surround non-numeric values with 'single quotes'. $sql = "update mytable s

RE: [PHP] mysql update help needed

2002-03-20 Thread Rick Emery
if ($postaction=="edit") -Original Message- From: ROBERT MCPEAK [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 11:44 AM To: [EMAIL PROTECTED] Subject: [PHP] mysql update help needed Can somebody straighten this out for me? I can't get the update to work. I'm sure the varia