Search code examples
phpsqllimit

MYSQL limit returns unexpected results

<?php
$quuuu = mysql_query("SELECT * FROM products limit 9,15 ") or die("Query Error");
while($ffff=mysql_fetch_array($quuuu)){
    echo "<li><a href='view.php?id=" . $ffff['id'] . "'>" . $ffff['title'] . "</a></li>";
}
echo mysql_num_rows($quuuu);
?>

its should return (7), and the result is (15)

Solution

  • Your LIMIT use is wrong.

    Syntax: limit start_at, amount_of_records

    If you want 7 elements starting at 15th element, you should use 

    SELECT * from products limit 14, 7