Business Correction
If you come across any incorrect business info, please edit the existing information to make the appropriate correction with your name and comment.
if($msg <> ''){ echo $msg; } else { if(isset($_COOKIE['ylat'])){$ylat=$_COOKIE['ylat'];}else{$ylat ="28.4521";} //echo $ylat; if(isset($_COOKIE['ylon'])){$ylon=$_COOKIE['ylon'];}else{$ylon ="-81.4678";} //echo $ylon; $selList="SELECT name, address, city, state, left(zip,5), phone, website, latitude, longitude, category, subcat1, round(SQRT(POW(69.1 * (latitude - $ylat), 2) + POW(69.1 * ($ylon - longitude) * COS(latitude / 57.3), 2)),1) AS distance, store_id, tagkey, facebook, twitter, delivery, smenu, yelpid FROM AllBusiness WHERE store_id = '$sid'"; $sql->Query($selList); for ($i=0;$i<$sql->rows;$i++) { $sql->Fetch($i); $name = $sql->data[0]; $name1 = str_replace("'","",$name);$name1 = str_replace("&","",$name1);$name1 = str_replace(" ","-",$name1); if ($isupper =='0'){$name=ucwords(strtolower($name));} $address = $sql->data[1]; $address=strtolower($address);$address=ucwords($address); $city = $sql->data[2]; $city1=strtolower($city);$city1=ucwords($city1); $state = $sql->data[3]; $state1=strtolower($state); $zip = $sql->data[4]; $phone = $sql->data[5]; $website = $sql->data[6]; $latitude = $sql->data[7]; $longitude = $sql->data[8]; $category = $sql->data[9]; $subcategory= $sql->data[10]; $distance = $sql->data[11]; $storeid = $sql->data[12]; //$list = "$name, $Address, $city, $state, $zip"; } $sql->Close(); echo $list ?> }?>