database_select("bateworldcom_zips"); $coslat=cos(deg2rad($_GET["lat"])); $sinlat=sin( deg2rad($_GET["lat"]) ); $radlon=deg2rad($_GET["long"]); $query=$database->database_query("SELECT country_code, place_name, admin_name1, admin_code1, postal_code, ( 3959 * acos( ".$coslat." * cos( radianslat ) * cos( radianslon - ".$radlon." ) + ".$sinlat." * sin( radianslat ) ) ) AS distance FROM bateworldcom_zips.zipcodes1 HAVING distance < 25 ORDER BY distance ASC LIMIT 0 , 10000"); $database->database_select("bateworld"); while($row=$database->database_fetch_array($query)) {// if($row["country_code"]=="US") { $query1=$database->database_query("SELECT * FROM se_users, se_profilevalues WHERE se_users.user_id=se_profilevalues.profilevalue_user_id AND se_profilevalues.profilevalue_27='".$row["postal_code"]."'"); while($row1=$database->database_fetch_array($query1)) { $owner1 = new SEUser(Array($row1["user_id"])); ?>
//