下面这段代码,为什么输出结果是5个相同的数据,我希望随机得到5个不同的结果,应该怎样修改,请高手指点!代码如下:
<?
$myconn=mysql_connect("localhost","root","");
mysql_select_db("test",$myconn);
$fir='select fir from first order by rand() ';
$sec='select sec from second order by rand() ';
$result1=mysql_query($fir);
$result2=mysql_query($sec);
$row1 = mysql_fetch_array($result1);
$row2 = mysql_fetch_array($result2);
for ($i=1; $i<=5; $i++)
{
?>
<li> <?echo $row1[0].$row2[0]?> </li>
<?
}
<?
$myconn=mysql_connect("localhost","root","");
mysql_select_db("test",$myconn);
$fir='select fir from first order by rand() ';
$sec='select sec from second order by rand() ';
$result1=mysql_query($fir);
$result2=mysql_query($sec);
$row1 = mysql_fetch_array($result1);
$row2 = mysql_fetch_array($result2);
for ($i=1; $i<=5; $i++)
{
?>
<li> <?echo $row1[0].$row2[0]?> </li>
<?
}
$myconn=mysql_connect("localhost","root","");
mysql_select_db("test",$myconn); $fir='select fir from first order by rand() limit 5 ';
$sec='select sec from second order by rand() limit 5'; $result1=mysql_query($fir);
$result2=mysql_query($sec); $row1 = mysql_fetch_array($result1);
$row2 = mysql_fetch_array($result2); for ($i=1; $i <=5; $i++)
{
?>
<li> <?echo $row1[i].$row2[i]?> </li>
<?
}