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

[PHP] mysql update help needed

2002-03-20 Thread ROBERT MCPEAK
Can somebody straighten this out for me? I can't get the update to work. I'm sure the variables are being passed to the code. Thanks! if ($postaction==edit) { echo "it fired"; // process form $db = mysql_connect("myhost, "myunam