<?include "conninfo.php";


//print_r($_POST);

$sn=$_POST["surname"];//data from form

$query="SELECT * FROM people WHERE surname like '$sn'";

$result=mysqli_query($link,$query);
$numrows=mysqli_num_rows($result);

if($numrows>0)
{

while($r=mysqli_fetch_array($result))
	{
	echo $r["id"]." ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["starsign"]."<br>";
	
	}
}
else
{
	echo "Nothing found";
}
?>
