".$q2."
";
echo "sename | name | quality | no |
";
while ($row = mysqli_fetch_array($result))
echo "".$row[0]." | ".$row[1]." | ".$row[2]." | ".$row[3]." |
";
echo "
";
$q1 = "DELETE FROM teachers WHERE sename='Фесенко';";
$result = mysqli_query($link, $q1);
$q2 = "SELECT * FROM teachers ORDER BY sename;";
$result = mysqli_query($link, $q2);
echo "".$q1."
".$q2."
";
echo "sename | name | quality | no |
";
while ($row = mysqli_fetch_array($result))
echo "".$row[0]." | ".$row[1]." | ".$row[2]." | ".$row[3]." |
";
echo "
";
$q1 = "DELETE FROM teachers ORDER BY sename LIMIT 4;";
$result = mysqli_query($link, $q1);
$q2 = "SELECT * FROM teachers ORDER BY sename;";
$result = mysqli_query($link, $q2);
echo "".$q1."
".$q2."
";
echo "sename | name | quality | no |
";
while ($row = mysqli_fetch_array($result))
echo "".$row[0]." | ".$row[1]." | ".$row[2]." | ".$row[3]." |
";
echo "
";
$q2 = "SELECT * FROM teachers;";
$result = mysqli_query($link, $q2);
echo "".$q2."
";
echo "sename | name | quality | no |
";
while ($row = mysqli_fetch_array($result))
echo "".$row[0]." | ".$row[1]." | ".$row[2]." | ".$row[3]." |
";
echo "
";
mysqli_close($link); // закриття сполучення
?>