<?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="enteredit.php" method="post">
			<input type="hidden" name="idtoedit" value="<?echo $r["id"];?>">	
			<input type="submit" value="Edit">			
			</form>
			

			<?
				echo "<br>";
				}
