Posted by Chuck Anderson on 11/23/05 01:02

julian_m wrote:

>Bob Stearns wrote:
>
>
>
>>Better than either:
>>
>>$sql = 'select * from articles where articles.id in ($arr_art_id)';
>>mysqlquery($sql);
>> //do whatever i have to do
>>
>>
>
>As you can imagine, I didn't know anything about "in".....
>
>thanks a lot
>
>
>
I've used IN for subqueries, but I'd never heard of using it with an
array. Can you really use the array just like that? After trying to find
more info on this, all I have seen indicates that you have to implode
the array into a comma separated list.

Si o no?

--
*****************************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
Integrity is obvious.
The lack of it is common.
*****************************

• Next in forum: Re: unlink() - just curious
• Prev in forum: Re: Warning: Unexpected character
• Thread view: Re: retrieving multiple rows advice

[Reply to this message]