PHP Mysql Query

$i = 0;
$sql = $data->select1(5,0);

while ($row = $db->fetch_row($sql)) {
    $i++;
    if($input->IsEven($i)){
        $even = "odd";
    } else {
        $even = "even";
    }
    if($row[4] == 0){ $row[4] = 1; }
    $count[$i] = ($row[4] / $row[5]) * 100;
    if($count[$i] == 99 || $count[$i] > 99){
        $room_fill = 5;
    } elseif($count[$i] > 65){
        $room_fill = 4;
    } elseif($count[$i] > 32){
        $room_fill = 3;
    } elseif($count[$i] > 0){
        $room_fill = 2;
    } elseif($count[$i] < 1){
        $room_fill = 1;
    }
    
    if($row[6] != "1"){ $row[3] = ""; }

printf("<li class=\"%s\">
    <span class=\"clearfix enter-room-link room-occupancy-%s\" title=\"".$lang->loc['go.to.room']."\" roomid=\"%s\">
        <span class=\"room-enter\">".$lang->loc['enter']."</span>
        <span class=\"room-name\">%s</span>
        <span class=\"room-description\">%s</span>
        <span class=\"room-owner\">".$lang->loc['owner'].": <a href=\"".PATH."/home/%s\">%s</a></span>
    </span>
</li>\n", $even, $room_fill, $row[0], $input->unicodeToImage($input->HoloText($row[1])), $input->unicodeToImage($input->HoloText($row[1])), $row[3], $row[3]);
}