Help with MYSQL code

[sellers3d]

i am trying to get some data out of MYSQL buy am having a time trying to figure out the correct way to get at it.

What I have:
an array of zipcodes that looks like this:
Array ( [12047] => 2.67 [12128] => 2.91 [12204] => 0.64 [12206] => 1.85 [12207] => 1.91 [12211] => 2.21 [12246] => 2.52 [12210] => 0 )

I need to go to a table that has events listed with zipcodes and pull out the events that correspond to the zipcodes in the above array.

The problem:
I need to print them in order by the date associated with the event, not by zip then date.

what I have tried that does not work:
foreach through the array get all the events that are associated with the zips in the array, then print the ones that are >()CURDATE AN.

I need to sort this data by date.

[NogDog]

// build list of zipcodes:
$zipArray = array();
foreach($zipcodes as $key => $val)
{
  $zipArray[] = $key;
}
$zipList = implode(',', $zipArray);
// if zipcode is not an integer field, then change the above to:
// $zipList = "'" . implode("','", $zipArray) . "'";

// build query:
$query = "SELECT * FROM events_table WHERE zipcode IN($zipList) AND date_col > CURDATE() ORDER BY date_col";

[sellers3d]

Wow.. thank you so much. Did it have to be so easy? Im going to look you up and send you 100 shares when I go public.

Dave