This Query Will Run In phpmyadmin, not through php

[hansman]

Here is my code

 

...$zip is from $_POST['zip']

 

 if (preg_match("/^\w{1,10}$/", $zip, $matches))
{
echo $zip;
$query = "SELECT Companies.Name, Companies.Phone, Companies.ZipCodes, Zips.ZipCode FROM Companies, Zips Where Zips.ZipCode='$zip'"; 
}
    
else{ // we don't bother querying the database
   echo "Not A Valid Zip Code";
}

while($row = mysql_fetch_array($query)){
echo "Zip Code Phone Numbers: " . $row['Companies.Phone'];
}

[revraz]

You didn't use mysql_query($query) anywhere in your code.