Re: Using SELECT IN with arrays

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux