在PHP中随机选择两行后获取变量 - Getting variables after Randomly selecting two rows in PHP

Getting variables after Randomly selecting two rows in PHP

我使用以下代码

$con=mysql_connect('localhost','admin',"password");
 $db=mysql_select_db('DbName',$con);
    $query="SELECT COUNT(shuffel.clientid) as total_users FROM shuffel";
    $result=mysql_query($query);
    $total=mysql_fetch_array($result);
    $total =$total['total_users'];
    if($total>=2)
    {
        $result=$total/2;
        $length =round($result);
        if ($length > 10)
            $length = 10;
        for($i = 0; $i < $length; $i++) 
        {
            $data = "SELECT * FROM shuffel ORDER BY RAND() LIMIT 2";
            $shuffeluser = mysql_query($data);
            int count = 0;
            while($row = mysql_fetch_assoc($shuffeluser))
            {
              $my_array[] = $row;
               count ++;
            }
                }

现在我想要一些类似的东西

$firstUserId = $my_array[0]->id;

然而Everhting只是空着回来。

上面的代码有什么问题

mysql_fetch_assoc()返回数组，而不是对象，所以去获取id，您应该使用$my_array[0]['id']。

还要考虑移动到PDO或mysqli_*，因为mysql_*已弃用。