RE: [PHP-DB] MySQL/PHP Update
| From: | Rick Emery | Date: | Thu, 28 Mar 2002 14:20:29 +0000 |
| Subject: | RE: [PHP-DB] MySQL/PHP Update | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17997@lists.php.net to get a copy of this message | ||
Jason, this is intriguing.
Please show us a bit more code before the mysql_query() call.
-----Original Message-----
From: Jason [mailto:bio@biohazardous.org]
Sent: Thursday, March 28, 2002 1:54 AM
To: Php-Db
Subject: [PHP-DB] MySQL/PHP Update
I'm trying to update my MySQL database, but it doesn't seem to be taking.
my code is:
mysql_query("update prod_list set prod_manu=$prod_man where sku='$prod'");
where
prod_manu is an int
$prod_man is an int
sku is a varchar
$prod is text
mysql_query() comes back successful, and just to be sure I echoed
mysql_error() and nothing came back.
What am I doing wrong?