php连接两个表然后查询数据代码，

来源：互联网发布：时间压缩知乎编辑：程序博客网时间：2024/06/04 08:33

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
<title>First program</title>
</head>
<body>

$t=@$_POST["student.学生学号"];

$coon=mysql_connect("localhost","root","su");
mysql_query('SET NAMES gbk');
mysql_select_db('school');

if (!empty($t))
{
$result=mysql_query("select * from 'sc','student' where 'sc'.'学生学号'='student'.'学生学号' 'student'.'学生学号'=$t");
}
else
{
$result=mysql_query("select * from sc,student where sc.学生学号=student.学生学号");
}

<?
while ($rs = mysql_fetch_array($result)) //用这个循环，要不然只能显示第一条

{
?>

<tr>
<td><? echo $rs['学生学号']?> </td>
<td> <?echo $rs['学生姓名']?> </td>
<td><? echo $rs['学生密码']?> </td>
<td><? echo $rs['性别']?> </td>
<td><? echo $rs['年龄']?> </td>
<td><? echo $rs['课程号']?> </td>
<td><? echo $rs['成绩'] ?></td>
</tr>
<?

}
echo "</table>";
?>

</body>
</html>
问题在哪里啊？？新手求教

0 0