Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Posted by Nobody Tebulo
Nobody Tebulo
13,233 Points

Your query needs to retrieve the books 11 through 20 from the database when ordered by title, check the OFFSET

limit data

1 Answer

Ari Misha
Ari Misha
19,323 Points
Ari Misha
Ari Misha
19,323 Points

Hiya Nobody! Lets just say you're creating a web app and working with a back-end language like PHP, and you're doing the pagination of your website. And your boss asked you to retrieve first 30 items(inclusive) from the database(lets consider mysql for this example). And This is what your code should look like:

$sql = "SELECT * FROM Orders LIMIT 30";

Now, she asks you to display the items range from 11 - 20(inclusive) from the database on the web page. Here comes the OFFSET clause to rescue. Here is how your code should look like:

$sql = "SELECT * FROM Orders LIMIT 10 OFFSET 10";

The above SQL query also says "return only 10 records, start on record 11 (OFFSET 10)". I hope it makes sense now. Good Luck! (: