while($row_d = mysql_fetch_array($result_d))
{
$row_now[] = $row_d[0]);
echo count($row_now);
}
$sql_e = "select userid from tmpuser where isdummy = 1 order by rand()";
$result_e = mysql_db_query($dbName,$sql_e);
while($row_e = mysql_fetch_array($result_e))
{
$row_now[]=$row_e[0];
}
$nums = count($row_now);
{
$row_now[] = $row_d[0]);
echo count($row_now);
}
$sql_e = "select userid from tmpuser where isdummy = 1 order by rand()";
$result_e = mysql_db_query($dbName,$sql_e);
while($row_e = mysql_fetch_array($result_e))
{
$row_now[]=$row_e[0];
}
$nums = count($row_now);
$sql_d = "select userid from tmpuser where isdummy = 0 order by logontime desc";
$result_d = mysql_db_query($dbName,$sql_d);
while($row_d = mysql_fetch_array($result_d))
{
$row_now[]=$row_d[0]);
}
echo count($row_now);//把这句话放到外面来应该好一点吧,因为你要的是总共有多小个元素,如果想记录循环的话,没有必要这样,直接用记数器的形式用一个变量$i来进行会速度快一点;
$sql_e = "select userid from tmpuser where isdummy = 1 order by rand()";
$result_e = mysql_db_query($dbName,$sql_e);
while($row_e = mysql_fetch_array($result_e))
{
$row_now[]=$row_e[0]);
}
$nums = count($row_now);
$sql_d = "select userid from tmpuser where isdummy = 0 order by logontime desc";
$result_d = mysql_db_query($dbName,$sql_d);
while($row_d = mysql_fetch_array($result_d))
{
$row_now[]=$row_d[0]);
}
echo count($row_now); $sql_e = "select userid from tmpuser where isdummy = 1 order by rand()";
$result_e = mysql_db_query($dbName,$sql_e);
while($row_e = mysql_fetch_array($result_e))
{
$row_now2[]=$row_e[0]);
}
$nums = count($row_now2);
$result = array_merge ($row_now, $row_now2);
print_r($result);
是不是这样的呢?如果array_merge有问题的话,可以考虑用别的方法,比如说转成字符串之后,合并两个字符串,然后再分隔字符串到一个数组中,对数组元素进行输出就可以了.
$conn = mysql_connect($host,$user,$pass);
mysql_select_db($dbName,$conn);
$row_now=array();
$sql_d = "select userid from tmpuser where isdummy = 0 order by logontime desc";
$result_d = mysql_db_query($dbName,$sql_d);
while($row_d = mysql_fetch_array($result_d))
{
array_push($row_now,$row_d[0]);
echo count($row_now);
}
$sql_e = "select userid from tmpuser where isdummy = 1 order by rand()";
$result_e = mysql_db_query($dbName,$sql_e);
while($row_e = mysql_fetch_array($result_e))
{
array_push($row_now,$row_e[0]);
}
$nums = count($row_now);
//echo $sql_d.$sql_e.count($row_d)."--".count($row_e)."--".$nums; //总页数
$pagesize = ceil($nums/$list_num); //限制翻页的范围
if (!isset($page) || $page < 1)
{
$page = 1;
}
if ($page > $pagesize)
{
$page = $pagesize;
} //设置循环的步长
if (($page == $pagesize) && (($nums % $list_num) != 0))
{
$step = $nums % $list_num;
}else{
$step = $list_num;
} //上下页
$prevpage = $page -1;
$nextpage = $page +1; //echo "第${page}页/共${pagesize}页<br>";
small_info();
//echo "($page/${pagesize})";
$begin = ($page - 1) * $list_num;
$i = 0;
?><select name="online"><?
while ($i<$list_num)
{
$iid = array_pop($row_now);
$sql_nickname = "select id,nickname from userinfo where id = $iid";
$result_nickname = mysql_db_query($dbName,$sql_nickname);
$row_nickname = mysql_fetch_array($result_nickname);
$i++;
?><option title="查看" value="" onpick="<?echo "onlineuserdetail.php?page=$page&userid=$iid&HLYD=$HLYD";?>"><?
echo stou($row_nickname[nickname])."...".stou($row_nickname[id]);
?></option><?
}
//显示下一页
if ($page < $pagesize)
{?>
<option title="下一页" value="" onpick="<?echo "$PHP_SELF?page=$nextpage&HLYD=$HLYD";?>">下一页</option>
<?}
//显示上一页
if ($page >1)
{?>
<option title="上一页" value="" onpick="<?echo "$PHP_SELF?page=$prevpage&HLYD=$HLYD";?>">上一页</option>
<?}?>
<option title="确定" value="" onpick="<?echo "freemain.php?HLYD=$HLYD";?>">返回上级</option>
<?echo joke_back();?>
</select><br/>
上面是我的代码。两个查询语句都能得到值的。谢谢个位老大了
<?echo joke_back();?>
这两个函数和我们讨论的东西没关系。
$result_d = mysql_db_query($dbName,$sql_d);
while($row_d = mysql_fetch_array($result_d))
{
array_push($row_now,$row_d[0]);
echo count($row_now); //请给出这里的输出结果
}
$arr2//你得到的数组结果集2
$arr3=array_merge ($arr1, $arr2);