<?php
include("opendb.php");
$cpxx_sql="SELECT * FROM `cpxxfb` WHERE ejlb=12 LIMIT 0, 30";
$cpxx_query=@mysql_query($cpxx_sql) or die("select from qyxx error!");
while($cpxx_array=mysql_fetch_array($cpxx_query))
{
echo $cpxx_array[scbj].'<br>';
}
?>
include("opendb.php");
$cpxx_sql="SELECT * FROM `cpxxfb` WHERE ejlb=12 LIMIT 0, 30";
$cpxx_query=@mysql_query($cpxx_sql) or die("select from qyxx error!");
while($cpxx_array=mysql_fetch_array($cpxx_query))
{
echo $cpxx_array[scbj].'<br>';
}
?>
{
$record=mysql_fetch_object($cpxx_query);
echo $cpxx_array[scbj].'<br>';
}
改为:
for($i=0;$i<$num_rows;$i++)
{
echo mysql_result($cpxx_query,$i,'scbj')."<br>";
}
while($cpxx_array=mysql_fetch_array($cpxx_query))
{
$a[$i]=$cpxx_array[scbj];
}
即将符合条件的纪录存放到$a中了,在对$a进行处理