dynamic variable plug into a mysql query?

this should work

$sql = "SELECT * FROM zipcodedb WHERE ";
$count = count($sqlarray);
$x =1;

foreach ($sqlarray as $zipcode)
{
    $sql .= "ZipCode = ".$zipcode;
    if($x++ < $count)
    {
        $sql .= " or ";
    }
}

Thank you for your response Kireol!

This looks like it is exactly what i need, but unfortunatly i need some further clarification on your code.

could you perhaps explain to me what i need to do with the $sqlarray and $zipcode variables before your code actually runs?

i'm assuming i need to set the results from the first sql query which spits out the 3 different zipcode in my original example into an array of some sort? i have never dealt with arrays before, so alittle extra help with this would be GREATLY appreciated. I understand and pick up on things quickly, so just a basic rundown of the process should be sufficient enough for me to get the idea and run with it.

Thank you again!

$sqlarray should be an array of zip codes. the result of your previous query. For testing and playing pursposes, you could manually make an array like:

$sqlarray = array ('12345','45678','76543');

$zipcode gets filled by PHP. It pops the first element off of the array specified in the foreach and each loop iteration it will fill the current value.

So the first time through the loop zipcode will = '12345' and the 2nd time '45678' and so on, given the sample array I posted above.

To take foreach and arrays 1 step further, you can also get the key

foreach($sqlarray as $key=>$value)

if you have a regular array, $key will have the array number (you COULD use this to replace my $x variable if you wanted to.) If it's an associative array 'customer1'=>'12345' then $key will have 'customer1' and value will have '12345'

hope that helps

EXCELLENT!

Thank you so much!!