作者Snylsh (Snylsh<(￣﹌￣)/)
看板PHP
标题[请益]请问一下表格的问题
时间Sat Jan 7 02:04:37 2006
http://203.71.42.77/view6.php 这是我目前做的网页
现在是学号 4910K001
姓名 王XX
学号 4910K002
姓名 李XX 这样累加下去
可是我想要的是
学号4910K001 4910K002 4910K003...
姓名王XX 李XX 林XX....
这样横向排列 请问该改哪里呢
<html>
<head>
<title>学生资料分页</title>
<head>
<body>
<?
$records_per_page =5;
if (isset($_GET["pages"]))
$pages = $_GET["pages"];
else
$pages=1;
$dbname="class";
$link = mysql_connect("localhost","root","02140423")
or die("无法开启");
$sql="SELECT * FROM stu";
$result=mysql_db_query($dbname,$sql);
$total_fields =mysql_num_fields($result);
$total_records = mysql_num_rows($result);
$total_pages=ceil($total_records/$records_per_page);
$offset = ($pages -1)* $records_per_page;
mysql_data_seek($result, $offset);
echo "纪录总数: $total_records<br>";
echo "<table border =3>";
$j=1;
while($rows = mysql_fetch_array($result, MYSQL_NUM)
and $j <= $records_per_page) {
echo"<tr>";
echo"<td>学号</td>";
echo"<td>"."<a href=\"csv4.php\">".$rows[0]."</a>"."</td>";
echo "</tr>";
echo"<tr>";
echo"<td>姓名</td>";
echo"<td>".$rows[1]."</td>";
echo "</tr>";
$j++;
}
echo "</table>";
echo "<br>显示页数: ";
for ($i=1; $i <= $total_pages; $i++)
if ($i != $pages)
echo "<a href=\"view5.php?pages=".$i."\">".$i."</a>";
else
echo $i. " ";
mysql_free_result($result);
mysql_close($link);
?>
</body>
</html>
--
We will be good friends for good .
You'll always be my upperclassman ,
and I'll be your lowerclasswoman .
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 203.71.41.233
1F：推 andreli:利用余数换排，或是CSS 01/07 08:52