选择插槽最大的行

Question

i need to select one row where slot_left is the biggest. i tried

for ( $i=1;$i<3;$i++) {
    $sql5 = "SELECT * from user u where (
        select max(slot_left) from company c,user u 
        where c.id=u.company_id and c.id='$name'
    )";
    $result5 = mysqli_query($link, $sql5) or die(mysqli_error($link));
    while($row=mysqli_fetch_array($result5)) {  
        // echo the id which the slot_left is the biggest      
        echo $i['slot_left'];
    }
}

but still cannot. please help!

Answer 1

1. SQL can be. You select all rows from DB.

   $sql5 = "select max(slot_left) AS slot_left from company c,user u where c.id=u.company_id and c.id='$name' GROUP by u.company_id";

2. $name variable used in query not set

3. Variable $i is not array. Array is $row

   echo $row['slot_left'];