i think the problem is bad syntax:
you should try:
mysql_query(update prod_list set prod_manu=$prod_man where sku='.$prod.');
that is because when you have single quotes you will not evaluate the
expression so your querry will do the update only for sku equally with
the string '$prod'...
hope
Jason, this is intriguing.
Please show us a bit more code before the mysql_query() call.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
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
On Thursday 28 March 2002 17:04, cristi radulescu wrote:
i think the problem is bad syntax:
you should try:
mysql_query(update prod_list set prod_manu=$prod_man where
sku='.$prod.');
that is because when you have single quotes you will not evaluate the
expression so your querry will do
Emery [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2002 7:20 AM
To: 'Jason'; Php-Db
Subject: RE: [PHP-DB] MySQL/PHP Update
Jason, this is intriguing.
Please show us a bit more code before the mysql_query() call.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March
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
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');
Try: mysql_query(update prod_list set prod_manu='$prod_man' where
sku='$prod');
Maxwell
--
PHP Database Mailing List
Jason a écrit :
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()