[Merovingian]

I am having some issues getting this new code implemented using a SQL Server as the DB and using odbc_connect to interface with the database.

The current script itself selects a postal code and outputs its contents if its available and a message when the person's postal code is not available in the database.

Now my dilemma is this:
There is another table with the following rows: Latitude, Longitude, Region, that was previously installed. What I would like to be able to do is that when a user enters their postal code, instead of showing an error message for when their zip isnt available in the database, to actually show another zip code that is within range ( a postal code search that outputs results with in range.) .
Please bare in mind that I do not wish to purchase any scripts but instead would like to learn how to do this. Any help would be appreciated.

What is being used at the moment for the normal search:

PHP Code:

 $query = "SELECT * FROM SonataLabs_DealerLocater WHERE (PostalCode LIKE '%$search%') ORDER BY DealerID";

$result = odbc_exec($connection, $query);



if(!$result)

{

    echo "<strong>No query was made !</strong>";

    }

    else

    {

print <<<EOF

<table width="80%" cellpadding="10" cellspacing="2" border="0" align="center">

<tr>

    <td bgcolor="#f2f2f2" width="250"><strong>Dealer Name</strong></td>

    <td bgcolor="#f2f2f2" width="150"><strong>Address</strong></td>

    <td bgcolor="#f2f2f2"><strong>Telephone</strong></td>

    <td bgcolor="#f2f2f2"><strong>Email</strong></td>

    <td bgcolor="#f2f2f2"><strong>URL</strong></td>

    </tr>

</td>

<tr>

    <td  width="250">

EOF;



while($row = odbc_fetch_array($result)  && $numRows = odbc_num_rows($connection, $query))

{



if($numRows < 0 )

{

    echo "There were no Dealers in your zip code area";    

   }else{



//Return the db queries

  echo strtolower($row['Name']);

  echo "</td><td  width='150'>";

  echo @$row['Street']; 

  echo "</td><td>";

  echo @$row['Phone'];

  echo "</td><td>";

  echo "<a href=\"mailto:".@$row['Email']." \">".$row['Email']."</a>";

  echo "</td><td>";

  echo @$row['URL'];

echo "</td>";

 // echo '</td><td>'.odbc_result($result,"Address").'</td>';

  echo "</tr>";

}

print <<<EOF

</table>

EOF; 

[NeverMind]

could you give more details about the "range" you are seeking?

[Merovingian]

something like this;

For example:

A user enters 33165, it will search for that zipcode and any other postal codes with in range(miles?) of the actual 33165 postal code. If nothing is within that postal code just output a "Nothing found near you".