<?include "conninfo.php";
include "banner.php";

$query="SELECT * FROM people,horoscope WHERE starsign=starsignid";

$result=mysqli_query($link,$query);

while($r=mysqli_fetch_array($result))//get rows
{
echo $r["firstname"]." ";
echo $r["surname"]." ";
echo $r["dateofbirth"]." ";
echo $r["starsignname"]." ";
echo "<br>";
	
}