求助~或许是小问题
- PHP code
<!---ecms Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->$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 "".$row["title"].""; 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:38本文来源gao.dai.ma.com搞@代*码(网$
搞代gaodaima码
6: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就没变过，肯定是一样的数据
——解决方案——————–
$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 “
“;
echo “
| “; echo “”.$row[“title”].””; echo “ |
“; echo “[“.$row[“author”].”]”; echo “ |
“; echo “[“.$row[“date”].”]”; echo “ |
“;
转载请注明原文链接：~或许是小疑点
