Zipcode to Advertiser Mailing Zone

[Anon]

We have a form where a person enters a zip code to find advertisers near their area.

To compare the zip to the zone we used:

$sql_zone = "SELECT zone FROM tbl_zone WHERE zip = $zip";

That part appears to work fine, but the $sql_result seems to be returning a number, not a zone value, (which is a letter). How do I get the zone value from this query?

[ace21]

$row = mysql_fetch_array($sql_zone)
$zone = $row[zone];

in the manual there is a whole section of mysql functions that might be helpful to you.

Ace21