Untitled

<!DOCTYPE html>
<html>
<head>
  <title>Фильмотека</title>
  <link rel="stylesheet" href="css/style.css">
</head>
<body class="body">
  <center>
  <a class="button8" href="index.php">Назад</a><br>
  <label class="sortlabel">Сортировать:</label><br>
  <form class="" action="show_all.php" method="post">
    <input class="button8 sort" type="submit" name="sort_by_id" value="По номеру">
    <input class="button8 sort" type="submit" name="sort_by_name" value="По названию">
    <input class="button8 sort" type="submit" name="sort_by_year" value="По году">
    <input class="button8 sort" type="submit" name="sort_by cost" value="По стоимости">
  <?php

  include "db.php";

  $query = "SELECT * FROM films ORDER BY Film_id ASC";
  $result = mysql_query($query) or die(mysql_error());

  echo '<center>';
  echo '<table class="table_dark"><tr><th>№</th><th>Название</th><th>Жанр</th><th>Год</th><th>Страна</th><th>Описание</th><th>Стоимость</th></tr>';
    echo '</center>';

  if(isset($_POST['sort_by_id']))
  {
      $query1 = "SELECT * FROM films ORDER BY Film_id ASC";
      $result1 = mysql_query($query1) or die(mysql_error());
      while ($row = mysql_fetch_array($result1))
      {
        echo '<tr align="center"><td>'.$row[0].'</td><td>'.$row[1].'</td><td>'.$row[2].'</td><td>'.$row[3].'</td><td>'.$row[4].'</td><td>'.$row[5].'</td><td>'.$row[6].'</td>';
      }
      exit;
  }

  if(isset( $_POST['sort_by_name']))
  {
      $query2 = "SELECT * FROM films ORDER BY Name";
      $result2 = mysql_query($query2) or die(mysql_error());
      while ($row = mysql_fetch_array($result2))
      {
        echo '<tr align="center"><td>'.$row[0].'</td><td>'.$row[1].'</td><td>'.$row[2].'</td><td>'.$row[3].'</td><td>'.$row[4].'</td><td>'.$row[5].'</td><td>'.$row[6].'</td>';
      }
      exit;
  }

  if( isset($_POST['sort_by_year']))
  {
      $query3 = "SELECT * FROM films ORDER BY Year";
      $result3 = mysql_query($query3) or die(mysql_error());
      while ($row = mysql_fetch_array($result3))
      {
        echo '<tr align="center"><td>'.$row[0].'</td><td>'.$row[1].'</td><td>'.$row[2].'</td><td>'.$row[3].'</td><td>'.$row[4].'</td><td>'.$row[5].'</td><td>'.$row[6].'</td>';
      }
      exit;
  }

  if(isset($_POST['sort_by_cost']))
  {
      $query4 = "SELECT * FROM films ORDER BY Cost";
      $result4 = mysql_query($query4) or die(mysql_error());
      while ($row = mysql_fetch_array($result4))
      {
        echo '<tr align="center"><td>'.$row[0].'</td><td>'.$row[1].'</td><td>'.$row[2].'</td><td>'.$row[3].'</td><td>'.$row[4].'</td><td>'.$row[5].'</td><td>'.$row[6].'</td>';
      }
      exit;
  }

  while ($row = mysql_fetch_array($result))
  {
    echo '<tr align="center"><td>'.$row[0].'</td><td>'.$row[1].'</td><td>'.$row[2].'</td><td>'.$row[3].'</td><td>'.$row[4].'</td><td>'.$row[5].'</td><td>'.$row[6].'</td>';
  }
  ?>
</form>
</center>
</body>
</html>