Looping a Select Statement for an Array

[dpalame]

I have the following code:

 

foreach ($at1 as $var)

{

$sql .= 'wfData.wfupc LIKE \'%' . $var . '%\' OR ';

}

$sql = substr($sql, 0, -4);

var_dump($sql);

 

 

$query = "SELECT wfStoreList.*

FROM wfStoreList

LEFT JOIN wfData ON wfStoreList.store=wfData.wfstore AND '$sql'

WHERE wfData.wfstore IS NULL ORDER BY '$var',region,store ASC ";

 

$result=mysql_query($query);

 

This works great for all variables in the array, but what I need to do is loop all variables in $at1 array separately and output the data as I go.  Can anybody help and/or point me in the right direction?  Thank you for your help.