3、获取pxscj数据库中女同学的总学分信息
<?php
$conn= mysql_connect('localhost','root','') or die('连接失败');
mysql_select_db('PXSCJ', $conn) or die('选择数据库失败');
mysql_query("SET NAMES gb2312");
$sql=" ___________________";
$result=mysql_query($sql);
echo "<table align=center border=1>";
echo "<tr><td>学号</td><td>姓名</td><td>总学分</td>";
while($row=mysql_fetch_row($result))
{
list($XH,$XM,$XB,$CSSJ,$ZY,$ZXF,$BZ)=$row;
echo "<tr><td>$XH</td><td>$XM</td><td>$ZXF</td></tr>";
}
echo "</table>";
?>