<?include "conninfo.php";?>

<h1>Database results:</h1>

<?
$query="SELECT * FROM people";
$result=mysqli_query($link,$query)or die("Didnt work");

while($r=mysqli_fetch_array($result))
{
echo $r["id"];
echo " ";
echo "<i>".$r["firstname"]."</i>";
echo " ";
echo $r["surname"];
echo " <b>";
echo $r["favfood"];
echo "</b> ";
echo $r["starsign"];
echo "<br>";
}