I am trying to find a way to plug some data that is spit out of a mysql query into another mysql query.
$zip1 = $_POST[zip1]; "SELECT * FROM zipcodedb WHERE ZipCode >= '". $zip1 ."'"
lets say i get that query to spit out these 3 results with a while loop :
now i need to take those three zipcodes and plug them into another mysql query
"SELECT * FROM zipcodedb WHERE ZipCode = 11758 OR ZipCode = 11759 OR ZipCode = 11760"
The part i am stuck on is this.
I need to figure out a way to dynamically populate the WHERE portion of this query because the above zipcodes will change depending on what was entered and submitted into the FIRST mysql query.
I'm trying to explain best as i can, my english is not perfect.
Thank you for any help anyone can offer.