求助~或许是小问题
PHP code
$query="SELECT * from news ORDER by id desc Limit $offset,$page_size";
$result=mysql_query($query,$conn);
$row=mysql_fetch_array($result);
$i=0;
while($i<$rows=mysql_num_rows($result)){
$i++;
echo "<p>";
echo "<table border='0' width='300'>";
echo "<tr>";
echo "<td>";
echo "<a href=View.php?id=".$row["id"].">".$row["title"]."</a>";
echo "</td>";
echo "<td>";
echo "[".$row["author"]."]";
echo "</td>";
echo "<td>";
echo "[".$row["date"]."]";
echo "</td>";
echo "</tr>";
}
echo "</table>";
显示结果为:
test4 [aa] [2012-02-24 15:36:00]
test4 [aa] [2012-02-24 15:36:00]
test4 [aa] [2012-02-24 15:36:00]
test4 [aa] [2012-02-24 15:36:00]
重复的次数为我数据库里存储的数据数目,怎么才能让它从第一条显示呢?
比如:
test1 [aa] [2012-02-24 15:36:00]
test2 [aa] [2012-02-24 15:36:00]
test3 [aa] [2012-02-24 15:36:00]
test4 [aa] [2012-02-24 15:36:00]
又来麻烦各位了,谢谢~^^
------解决方案--------------------
更正一下是row
while($row=mysql_fetch_array($result)){
探讨 //$row=mysql_fetch_array($result); // 删了 while($rows=mysql_fetch_array($result)){
------解决方案-------------------- 你的$row就没变过,肯定是一样的数据
------解决方案--------------------
$query="SELECT * from news ORDER by id desc Limit $offset,$page_size";
$result=mysql_query($query,$conn);
//$row=mysql_fetch_array($result); 这行放到while条件
不需要这个$i
//while($i<$rows=mysql_num_rows($result)){
//$i++;
while($row=mysql_fetch_array($result)){
echo "<p>";
echo "<table border='0' width='300'>";
echo "<tr>";
echo "<td>";
echo "<a href=View.php?id=".$row["id"].">".$row["title"]."</a>";
echo "</td>";
echo "<td>";
echo "[".$row["author"]."]";
echo "</td>";
echo "<td>";
echo "[".$row["date"]."]";
echo "</td>";
echo "</tr>";
}
echo "</table>";