<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.学生学号");
}
?>
<table width='60%' border='2' color='r' align='center'>
<tr><td>学生学号</td><td>学生姓名</td><td>学生密码</td><td>性别</td><td>年龄</td><td>课程号</td><td>成绩</td></tr>
<?
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>
问题在哪里啊??新手求教