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 variables are being
passed to the code.  Thanks!

if ($postaction==edit)

{
echo it firedBr;
// process form

$db = mysql_connect(myhost, myuname,
mypword);

 mysql_select_db(mydb);

$sql = UPDATE mytable SET
img_url=$img_url,visitdate=$visitdate,img_group=$img_group,display=$display,
caption=$caption where id = $id;

$result = mysql_query($sql);

echo center;
echo Thank you! Information entered.\n;
echo /center;

}

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 img_url='$img_url', 

etc.

miguel


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php