Welcome";
$query="SELECT * FROM people"; //select all fields;
$result=mysqli_query($link,$query);//actually run query
while($r=mysqli_fetch_array($result)) //mysqli_fetch_assoc as an alternative
{
echo $r["id"]." ";
echo $r["firstname"]." ";
echo $r["surname"]." ";
echo $r["favfood"];?>
";
}
?>