mysql update help needed
| From: | ROBERT MCPEAK | Date: | Wed, 20 Mar 2002 17:43:41 +0000 |
| Subject: | mysql update help needed | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-89360@lists.php.net to get a copy of this message | ||
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<Br>";
// 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>";
}