[RESOLVED] What should this simple query be?

[php_noob2]

Hello all,

I'm using this slick pagination class in the url below to hack apart and learn from but I can't figure out what query I'm supposed to use to get the result. Yes, it's an embarrassingly easy question but I can't seem to get it.

http://www.catchmyfame.com/2007/07/28/finally-the-simple-pagination-class/

many thanks in advance! 🙂

---

OSX 10.5.3, PHP 5.2.5, MySQL 5.0.45

[bretticus]

This class simply does pagination for you. It does not actually print out your data (you do that.) It simply alters your SQL query to LIMIT the records you return (my guess, MySQL only, but probably easy to alter.) Note the part in instructions:

// Make your db query here. Include $pages->limit as described in step 8.
(i.e. SELECT id,fname,lname FROM employees $pages->limit)

This just means, write all your code for displaying results here with the one requirement of appending the $pages->limit variable to your SQL query. Because that automatically controls what record to start at and how many records to pull.