<?include "conninfo.php";
include "banner.php";

$query="SELECT * FROM people,starsignlist WHERE starsign=sid ORDER BY firstname";

$result=mysqli_query($link,$query);

while($r=mysqli_fetch_array($result))//get row
	{
	echo $r["id"]." ";			//get id field in row
	echo $r["firstname"]." ";	//get firstname field in row
	echo $r["surname"]." ";
	echo $r["favfood"]." ";
	echo $r["starsignname"]." ";
	echo $r["userlink"];?>
	<form action="delete.php" method="post">
	<input type="hidden" value="<?echo $r["id"];?>" name="theid">
	<input type="submit" value="Delete">
	</form>
	
	<form action="changedata.php" method="post">
	<input type="hidden" value="<?echo $r["id"];?>" name="theid">
	<input type="submit" value="Edit">
	</form>
	<?
	}
	?>
<a href="enternewdata.php">Insert record</a>