How can I convert the following script to be used in access?
<Html>
<head>
<title>Dealer s</title>
</head>
<h5>List of Dealers Nearest to your Zip Code</h5><br><br>
<?
$errflag = false;
$conn = mysql_connect(" localhost:3306" ,"uid","pass ");
mysql_select_db ("tbcdealers ");
$query = "select * from zipcode where Zipcode = '" . $txtZip . "'";
$result = mysql_query($qu ery,$conn);
$row = mysql_fetch_row ($result);
if ($row == false) {
$errflag = true;
$errmsg = "The Zip Code you entered is invalid";
echo "<blockquote>$e rrmgs</blockquote>";
}
else {
$lat1 = $row[3];
$long1 = $row[4];
}
if ($errflag == false){
$sql = "select zipcode.zipcode , sqrt(power(69.1 *(zipcode.latit ude - $lat1),2)+
power(69.1*(zip code.longitude-$long1)*cos(zip code.latitude/57.3),2)) as dist,
$dealer.* from $dealer LEFT JOIN zipcode on " ;
$sql = $sql . " $dealer.zip = zipcode.zipcode where
sqrt(power(69.1 *(zipcode.latit ude - $lat1),2)+
power(69.1*(zip code.longitude-$long1)*cos(zip code.latitude/57.3),2)) < " .
$cboDist ;
$result = mysql_query($sq l,$conn);
$count = mysql_num_rows( $result);
echo "<blockquote><t able border=0>";
for ($i=0; $i < $count; $i++) {
echo "<tr><td>";
$row = mysql_fetch_row ($result);
echo "<b>",$row[3],"</b><BR>" ;
echo $row[4],"<BR>" ;
if ($row[5] <> ""){
echo $row[5],"<BR>" ;
}
echo $row[6],"<BR>" ;
echo $row[7],"<BR>";
echo $row[8],"<BR>";
$dm = sprintf("%3.2f" ,$row[1]);
echo "Distance : $dm miles.<BR><BR>" ;
echo "</td></tr>";
}
