<?php   
    
    $query ="SELECT * FROM country1";  
       
    $result = mysqli_query($link, $query) or die("Помилка " . mysqli_error($link));  
    if($result)  
    {  
        $rows = mysqli_num_rows($result); // кількість отриманих рядків  
           
        echo "<table class='outtable2'><tr><th></th><th>Країна</th><th>Столиця</th><th>Населення</th><th>Прапор</th><th>Континет</th></tr>";   
        for ($i = 0 ; $i < $rows ; ++$i)  
        {  
            $row = mysqli_fetch_row($result);  
            echo "<tr>";  
                for ($j = 0 ; $j < 6 ; ++$j) echo "<td>$row[$j]</td>";  
            echo "</tr>";  
        }  
        echo "</table>";  
           
           
        // очищуємо результат  
        mysqli_free_result($result);  
    }  
    mysqli_close($link);  
    ?>  

   $query ="SELECT * FROM `country1` WHERE continent='Африка'";

    $query ="SELECT * FROM `country1` WHERE `continent`='Європа' AND `population`>'5'";

      $query ="SELECT * FROM `country1` WHERE `continent`='Америка' OR `population`>'50'";

       $query ="SELECT * FROM `country1` WHERE `continent`='Європа'  `country`";  

       $query ="SELECT * FROM `country1` WHERE `continent`='Європа' ORDER BY `country`";  

 $query ="SELECT * FROM `country1` WHERE (`continent`='Європа' AND `population`<5) OR `id`<3";