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

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 set