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 this help,
cristi radulescu

MU> 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() comes back successful, and just to be sure I echoed
>> mysql_error() and nothing came back.
>>
>> What am I doing wrong?

MU> if you already have an row with that data, mysql doesn't update the db...

MU> do an echo $query to see what exactly is executed.
MU> ($query = "update prod_list set prod_manu=$prod_man where sku='$prod'")


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

Reply via email to