Witam. Po wykonaniu pliku php wyświetlają mi się powtarzające rekordy. Czy jest sens robić funkcję ograniczającą wyświetlanie powtarzających danych, albo czy da się to napisać w MySQL. Próbowałem DISTINCT i nie działa.

[PHP] pobierz, plaintext 
if ((empty($_GET['page'])) || ($_GET['page']) == 1 )
    {
        $how_much_loops = 0;
 
        for ($i = 0; $i <= mysql_num_rows($result); $i++)
        {
            $i =  mysql_real_escape_string($i);
            if (isset($_SESSION['sortby']) && isset($_SESSION['dir']))
            {
                $sortby = $_SESSION['sortby'];
                $dir = $_SESSION['dir'];
                $sortby = mysql_real_escape_string($sortby);
                $dir = mysql_real_escape_string($dir);
                $query = "SELECT * from table_books ORDER BY $sortby $dir LIMIT 10 OFFSET $i";
            }
 
            else $query = "SELECT * from table_books LIMIT 10 OFFSET $i";
             //$query = "SELECT * from table_books ORDER BY book_name DESC LIMIT 10 OFFSET $i";
 
            if ($how_much_loops >= 10) break;
            echo "<tr>";
 
            $result = mysql_query($query) or die(mysql_error());
            $row = mysql_fetch_assoc($result);
            if ($row['binding'] == 1)
            $row['binding'] = "hard";
            else $row['binding'] = "soft";
 
            if ($row['availability'] == 2)
                $row['availability'] = "available";
            else if ($row['availability'] == 0)
                    $row['availability'] = "not available";
            else if ($row['availability'] == 1)
                $row['availability'] = "ordered";    
            $book_id = $row['book_id'];
            echo "<td>".($i+1)."</td>";
            echo "<td>".$row['book_id']."</td>";
            echo "<td>".$row['book_name']."</td>";
            echo "<td>".$row['author']."</td>";
            echo "<td>".$row['publishing_house']."</td>";
            echo "<td>".$row['year_of_publication']."</td>";
            echo "<td>".$row['binding']."</td>";
            echo "<td>".$row['availability'] ;
 
 
            if ($row['availability'] == "available")
            {
                if (isset($_SESSION['logged']))
                {
                    if (($_SESSION["logged"] == 2))
                    {
                        echo "<a href='order_book.php?book_id=$book_id'> | Order</a>";
 
                    }
                    echo "</td>";
                }
            }
            echo "</td>";
 
 
 
 
 
            $how_much_loops++;
         }
    echo "</tr></table>";
    }
[PHP] pobierz, plaintext