<?php
$dbname = 'lpps';// database name
$dbuser = 'root';// database user name
$dbpass = '';// database password
$dbhost = 'localhost';// database host
mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to database"); // Connection string
mysql_select_db("lpps");

$my_lat=11.19998;
$my_lng=76.95386;
$dist=10; #10 miles radius

// $my_lat and $my_lng are fixed latitude and longitude.
// Latitude and longitude in belo mysql query is from database
// Result displays ID, Name, Place and Blood Group of peoples

$sql="SELECT *,
    ( 6371 * acos(
    cos(radians($my_lat)) * cos(radians(latitude)) * cos(radians(longitude) - radians($my_lng)) +
    sin(radians($my_lat)) * sin(radians(latitude))
    ) ) AS distance
FROM `sample`
 HAVING distance < $dist
ORDER BY distance LIMIT 10";


$query = mysql_query($sql) or die(mysql_error());
		$count=mysql_num_rows($query);
		while($row = mysql_fetch_assoc($query)) {

		echo $row['id']." &nbsp;&nbsp; ".$row['name']."&nbsp;&nbsp;".$row['place']."&nbsp;&nbsp;".$row['blood']."<BR>";
					}

?>