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

$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 row
				{
				echo $r["id"];
				echo $r["firstname"];
				echo $r["surname"];
				echo $r["email"];
				echo $r["postcode"];?>
				
			<img src="images/<?echo $r["image"];?>" width="100">
			<a href="<?echo $r["favlink"];?>">Click me</a>
			
			<form action="dodelete.php" method="post">
			<input type="hidden" name="idtodelete" value="<?echo $r["id"];?>">
			<input type="submit" value="Delete">
			</form>
			
			
				<?
				echo "<br>";
				}
