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?
if you already have an row with that data, mysql doesn't update the db...
do an echo $query to see what exactly is executed.
($query = "update prod_list set prod_manu=$prod_man where sku='$prod'")
--
Marius Ursache (3563 || 3494)
\|/ ____ \|/
"@'/ ,. \`@"
/_| \__/ |_\
\__U_/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
