Ok, solved that problem, can anyone help me on my last query, i need to select
categories that are not the following id's, this is what i have:
select * from category_table where catid ! in ('2','4')
Can anyone help me?
James
-----Original Message-----
From: Ignatius Reilly [mailto:ignatius.reilly@;free.fr]
Sent: Fri 25/10/2002 12:57
To: James Meers; PHP Helplist Windows
Cc:
Subject: Re: [PHP-WIN] MySQL Query
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" <[EMAIL PROTECTED]>
To: "PHP Helplist Windows" <[EMAIL PROTECTED]>
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
>
>
