Posted by Jason Wong on 10/04/64 11:07

On Thursday 03 February 2005 07:58, W Luke 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)

> So basically I need to find *all* domains in $d (dom1.com,dom2.net)
> which appear in $doms,
>
> then extract all the other info
> (mq.user,mq.sender etc).

--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
New Year Resolution: Ignore top posted posts

• Next in thread: Re: [PHP] Using SELECT IN with arrays
• Prev in thread: Using SELECT IN with arrays
• Next in forum: Re: [PHP] problems with session timeout
• Prev in forum: Re: How to make binary strings useful?
• Thread view: Using

[Reply to this message]