Rick 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:
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
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, b
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'...
ho
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
>
>
> 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 (http:
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
