Re: MySQL Query
| From: | Ignatius Reilly | Date: | Fri, 25 Oct 2002 11:57:12 +0000 |
| Subject: | Re: MySQL Query | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-16549@lists.php.net to get a copy of this message | ||
arrays are not a datatype for MySQL.
You have to serialize your array into a string. You must choose a suitable
delimitor that will not conflict with your data. Taking as an example ",":
$to_feed = implode( "," , my_array ) ;
$query = " update user_table set categories in '({$to_feed})' where
userid='1' " ;
HTH
Ignatius
____________________________________________
----- Original Message -----
From: "James Meers" <jambo@venda.com>
To: "PHP Helplist Windows" <php-windows@lists.php.net>
Sent: Friday, October 25, 2002 1:39 PM
Subject: [PHP-WIN] MySQL Query
> i want to update a field and add an array, this is what i have so far,
however it doesnt work, can anyone help?
>
> update user_table set categories in ('5','6') where userid='1'
>
>
>
> James
>
>