$str_sql

"; $result=mysql_db_query($dbname,$str_sql) or die(mysql_error()); if ($result) while($row = mysql_fetch_object($result)) { $array_market[$row->id]=$row->market_name; // echo "
ID: ".$row->id." 市场名: ".$row->market_name; } mysql_free_result($result); //echo "

array_market 数组大小为: ".sizeof($array_market)."

"; $str_sql="select * from $table_unit"; // echo "

$str_sql

"; $result=mysql_db_query($dbname,$str_sql) or die(mysql_error()); if ($result) while($row = mysql_fetch_object($result)) { $array_unit[$row->name]=$row->id; // echo "
ID: ".$row->id." 计量单位: ".$row->name; } mysql_free_result($result); //echo "

array_unit 数组大小为: ".sizeof($array_unit)."

"; $str_sql="select * from $table_currency"; // echo "

$str_sql

"; $result=mysql_db_query($dbname,$str_sql) or die(mysql_error()); if ($result) while($row = mysql_fetch_object($result)) { $array_currency[$row->name]=$row->id; // echo "
ID: ".$row->id." 货币单位: ".$row->name; } mysql_free_result($result); //echo "

array_currency 数组大小为: ".sizeof($array_currency)."

"; $query="select market_id from $table_price group by market_id"; $result = mysql_db_query($dbname,$query); $res_count=@mysql_num_rows($result); mysql_free_result($result); //$res_count=sizeof($array_market); $rowsperpage = 20; echo $name."蔬菜市场共有".$res_count."个"; if ($page<0) $page=0; $offset = $page * $rowsperpage; $endpage=ceil($res_count/$rowsperpage-1); if ($page>$endpage) $page=$endpage; if ($res_count<=0) echo "。
"; else { echo "【第".($offset+1)."个－第"; if ($res_count<$offset+$rowsperpage) echo $res_count; else echo $offset+$rowsperpage; echo '个】。

'; $query="select market_id ,max(date) as pubdate from $table_price group by market_id order by pubdate DESC limit $offset,$rowsperpage"; $result = mysql_db_query($dbname,$query); while ($row = mysql_fetch_object($result)) { echo ' '; } mysql_free_result($result); echo '

价格行情:
'.$array_market[$row->market_id].' ('.$row->pubdate.')
'; if ($page) { $prevpage = $page - 1; echo "头".$rowsperpage."个"; echo " 前".$rowsperpage."个"; } if ($page <$endpage) { $nextpage = $page + 1; echo " 后".$rowsperpage."个"; echo " 末".$rowsperpage."个"; } } ?>