MySQL Query Limiting

[Man1c M0g]

This is a thread to discuss the MySQL Query Limiting tutorial. Please keep all posts on-topic, don't spam, and read the entire thread BEFORE you post - any issues you have could be answered deeper within the thread.

[tid]

Anybody getting an error relating to the section:

$query = mysql_query(“SELECT * FROM OurTable LIMIT ‘$start’, ‘$limit’”)

may want to try removing the single quotes " ' " around $start and $limit. This was causing MySQL syntax errors for me.

Great tutorial btw, thanks

[notjustgraphics]

I believe the last few lines of the script have some errors.

Try this instead:

PHP Code:

$previous = $start - $limit; //changed operator
$next = $start + $limit; //changed operator
echo '<a href="index.php?page='.$previous.'">Previous Page</a> - '; //changed 'start' to 'page'
echo '<a href="index.php?page='.$next.'">Next Page</a>'; //changed 'start' to 'page'

// the set of statements above displays the previous and next page links