<?include "conninfo.php";  //database connection

$query="SELECT * FROM people";  //set up the query into a variable
$result=mysql_query($query);	//run the query

					
					
while($r=mysql_fetch_array($result))//get rows, one by one
{
echo $r["id"];
echo $r["firstname"];
echo $r["surname"];
echo $r["email"];
echo $r["postcode"];
echo "<br>";
}
