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

Reply via email to