首頁 >後端開發 >php教程 >~或许是小疑点

~或许是小疑点

WBOY
WBOY原創
2016-06-13 10:10:301053瀏覽

求助~或许是小问题

PHP code
<!--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";    echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
"; echo "".$row["title"].""; echo ""; echo "[".$row["author"]."]"; echo ""; echo "[".$row["date"]."]"; echo "
";


显示结果为:
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//$i++;


while($row=mysql_fetch_array($result)){
echo "

";
echo "

";
echo "";
echo "";
echo "";
echo "";
echo "";
}
echo "
";
echo "".$row["title"]."";
echo "
";
echo "[".$row["author"]."]";
echo "
";
echo "[".$row["date"]."]";
echo "
";
陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn