<?include "conninfo.php";  //make connection to db available;

$query="SELECT * FROM people";//set up the query;
$result=mysqli_query($link,$query)or die("Failed to do query");

while($r=mysqli_fetch_array($result))		//get row
{
echo $r["id"];
echo " ";
echo $r["firstname"];
echo " ";
echo $r["surname"];
echo " ";
echo $r["dateofbirth"];
echo " ";
echo $r["starsign"];
echo "<br>";
}


?>