Re: MySQL/PHP Update
| From: | Marius Ursache | Date: | Thu, 28 Mar 2002 08:06:36 +0000 |
| Subject: | Re: MySQL/PHP Update | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17981@lists.php.net to get a copy of this message | ||
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_/