<?include "conninfo.php";
//print_r($_POST);

$theid=$_POST["thejob"];

$query="SELECT * FROM people,horoscope WHERE job=$theid AND starsign=sid";
$result=mysqli_query($link,$query);

while($r=mysqli_fetch_array($result))//get row
	{
	echo $r["id"]."  ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["starsignname"]." ";
	echo $r["favfood"]."<br>";
	
	}



?>