SELECT with an array

cmoore67

Can I do a search for all the values within an array, or do I have to use a FOR loop to search for each one individually?

Will this work?
SELECT * FROM table WHERE ZIP = $ZIP[];
if not, what will?

thanks,
Chris

reagent

why not do this:
$strQuery = "
SELECT *
FROM table
WHERE ZIP
IN (".implode(",", $ZIP).")";

good luck

cmoore67

what exactly does that do? sorry but my skills are in the development stage.

Thanks for your time,
Chris

Anon

the implode function goes through the array and creates a list such that
$zip[0] = "95112"
$zip[1] = "11234"
$zip[2] = "01123"
...
$zip[n] = "...."
will become 95112,11234,01123...,n

then the sql statement says
select * from table where zip
IN (95112, 11234, 01123 etc)

the IN clause (in oracle atleast) is like an or statement so essentially you're asking your database to select everything from table where zip is either 95112, OR 11234 or 01123 or ... n (down the line)

hope that helps

jm ^_

cmoore67

It worked, thank you both very very much.

One more question.

How do I search for more than one identifier?

My first instinct is:

SELECT * FROM table WHERE id IN (".implode(",", $id_bus).") AND metro = $metro";

but it hasn't worked.

Thanks for your time,
Chris

Anon

You may want to try two things:

1.) switch the order of the and the in keywords

SELECT *
FROM tableName
WHERE column1 = '$column1value' AND column2 IN (.... code )

2.) do subselects
SELECT *
FROM tableName
WHERE column1 = '$column1value' AND column2 IN
(SELECT column2
FROM tableName
WHERE column2 IN (...code));

jm ^_