Posted by W Luke on 10/04/38 11:07

On Thu, 3 Feb 2005 08:37:44 +0800, Jason Wong <php-general@gremlins.biz> wrote:

> > $doms is a "master array" of a user's domains. $d is a
> > comma-seperated and unexploded list of domains to filter the SELECT
> > down with. (error checking is already in place)
>
> 1) make both $d and $doms into array
> 2) use array_intersect() to find the $d's that match $doms
> 3) convert the matches into a comma separated string with single quotes around
> the individual values
> 4) SELECT blah WHERE domain IN(comma separated string with single quotes
> around the individual values)

Wicked - thanks Jason

--
Will The Corridor of Uncertainty http://www.cricket.mailliw.com/
- Sanity is a madness put to good use -

• Next in thread: Using a recursive ArrayIterator
• Prev in thread: Re: [PHP] Using SELECT IN with arrays
• Next in forum: Re: [PHP] Is there a function to c if a php function exists
• Prev in forum: Re: [PHP] problems with session timeout
• Thread view: Using

[Reply to this message]