On Wednesday 15 January 2003 01:47, Kelly Meeks wrote:
> I've got an array of values, that I need to query against a database to see
> if any records have any of the values in the array - the array is a list of
> zip codes, and the database contains a list of stores. Basically i need to
> find what stores have zip codes in the array.
>
> I know that mysql doesn't support subquerys - is there a workaround for
> this kind of scenario?
This is more of a mysql question and should be asked on the php-db list if not
the mysql list.
What you need is something like:
"SELECT doo FROM dah WHERE dee IN('val1', 'val2', ..., 'valN'"
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
PEGGY FLEMMING is stealing BASKET BALLS to feed the babies in VERMONT.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
