<?
/* Created by Hirsh Agarwal of H2 Micro (www.h2micro.com) */

function searchLocation ($longitude, $latitude, $radius){

  //Fields
  $searchResults = array();
  //Define Server Variables
	$db = ""; //Set Database Name
	$host = ""; //Set Database
	$dbPassword = ""; //Set Database Password
	$dbUsername = ""; //Set Database Username

  //Connect to mySQL Server
  mysql_connect($host, $dbUsername, $dbPassword, $db);
  //Select Database
  mysql_select_db($db);

  //Query the database
  $result = mysql_query("SELECT
    id, (
    3959 * acos (
    cos ( radians('$longitude') )
      * cos( radians( latitude ) )
      * cos( radians( longitude ) - radians('$longitude') )
    + sin ( radians('$latitude') )
      * sin( radians( latitude ) )
    )
    ) AS distance
    FROM events
    HAVING distance < '$radius'
    ORDER BY distance
    	LIMIT 0 , 20;") or die (mysql_error()); //Make sure to update longitude and latitude to reflect the lat/long values as stored in your database
  while($row = mysql_fetch_array($result)){
    $currentResult = $row['searchVar']; //Update search var as variable that you are searching for
    array_push($searchResults, $currentResult)
  }

  return $searchResults;

}



?>