$s="SELECT c.capacity, f.name, c.classname from class c inner join faculty f on f.id=c.facultyid WHERE c.id NOT IN ( SELECT classid from cc where (dayid=$dayid and timeid=$kactabasliyor)  or (dayid=$dayid and timeid=$kactabasliyor+1)) and c.capacity>=$search_value";
        <span class="userTag">@$tumveri=$db-></span>prepare($s);
        <span class="userTag">@$tumveri-></span>execute();
        <span class="userTag">@$sonuc=$tumveri-></span>get_result();
 
 
while ($satir=$sonuc->fetch_assoc()):
        echo '<tr>
         <td>'.$satir["capacity"].'</td>
        <td>'.$satir["classname"].'</td>
        <td><a href="URL">'.$satir["name"].'</a></td>
        
      </tr>';
        
        endwhile;