Forum Moderators: open
I am trying to use data from one of my PHP arrays to perform a select in SQL... I hav never tried my hand at this and have been browsing the topic but haven't been able to find any reliable info... Any tips or ideas would be greatly appreciated!
$narray["$zip1"]="$red"; (this is inside a loop and so resturns several rows)
asort($narray);
foreach($narray as $key => $value)
{
print $key . " = " . $value . "<br />";
}
$query="SELECT * FROM schools WHERE zip = '$key'";
$result=mysql_query($query) or die ("Query failed");
Of course there are several keys and I suppose I'd need some loop but I can't seem to link both in my head and picture the global idea... :(
Thanks!
Andie
For instance if your key in your table are integer values, you my try to builds a string that looks like:
SELECT * FROM schools WHERE zip IN (28226, 28225, 28211)
if your PhP array has the values 28226, 28225, and 28211 in it.
If your key in your table is a string value, you may try to build a string that looks like:
SELECT * FROM schools WHERE zip IN('28226', '28225', '28211')
Simply cycle through the table concatenating your zips into a string like "(28226, 28225, 28211)" and then concatenate the resulting string of zips onto the end of another string that contains "SELECT * FROM schools WHERE zip IN ".
Note: It's okay if the array only has one value in it.
SELECT * FROM schools WHERE zip IN (28226) is logically equivalent to SELECT * FROM schools WHERE zip = (28226).
[edited by: ZydoSEO at 8:55 pm (utc) on Dec. 27, 2007]
Thanks :) I had ended up creating a variable with the following: "OR zip = '3333' OR zip = '2344'" etc and using it in my query but the IN method is much better!
Thanks
Andie
