php页面只显示表里的一个数据库,php-为什么只从我的数据库中提取1个表中的记录...

我是编程新手.在我仍是学生的几个小时后,我似乎无法修复它,这是我的论文.

我正在尝试从两个表中获取记录

>囚桌

>探视表-该表具有囚犯ID外键,因此,如果我单击犯人,它也会显示其探视记录.

这是我的代码：

include "connect.php";

$id = $_GET['id'];

$result = $connect->query(

"SELECT * FROM prisoner

INNER JOIN visitations ON prisoner.prisoner_id = visitations.prisoner_id

WHERE prisoner.prisoner_id = $id"

) or die($connect->error);

$visit = $connect->query(

"SELECT visitor,date_of_visit,time_of_visit,affinity,homeAddress FROM visitations

INNER JOIN prisoner ON prisoner.prisoner_id = visitations.prisoner_id

WHERE visitations.prisoner_id = $id"

) or die($connect->error);

主持人表

while($row = $result->fetch_assoc()){

$id = $row['prisoner_id'];

$photo = $row['photo'];

$gname = $row['givenName'];

$mname = $row['middleName'];

$lname = $row['lastName'];

$aname = $row['nickname'];

<?php echo "";

echo "
$gname $mname $lname";

?>

echo "

Nickname: $aname

";

}

参观

Visitations