在MySQL WHERE子句中使用数组“键”

Question

I have a data set that is generated by a Zip Code range search:

$zips:

key -> value
11967 -> 0.5
11951 -> 1.3

The key is the Zip Code (Which I need to query the Database for), and the value is the miles from the user entered zip code. I need to take the key (Zip Code) and search the database, preferably using a MySQL query similar to my current one:

$getlistings = mysql_query("SELECT * FROM stores WHERE zip IN ($zips)");

The other alternative is to change the array somehow in my code. I tried looking in code for where the array is generated originally but I couldn't find it. Any help would be greatly appreciated!! Thanks :)

Answer 1

array_keys should be what you're looking for.

$zip = array_keys($zips);      # gives you simple array(11967, 11951);
implode(', ', $zip);           # results in: '11967, 11951'