~或許是小疑點

求助~或許是小問題

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 "
";    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<$rows=mysql_num_rows($result)){
//$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 "

";

