Auto Page Generation Code Help

[Anon]

I am a newbie PHP/MySQL victim and I'm having a problem doing something.

I have a page that displays records w/pictures. How can I make the page only display a select number of records (i.e. 10) per page with a links at the bottom for pages displaying 10 more, 10 more, etc.?

If anyone needs me to put my existing code, let me know.

Thanks.

[Anon]

try a limit with the query at the end

eg: SELECT * FROM newbie LIMIT 0,10

0 is which record to start at, 10 is how many to show from their.

i'm sure you can code up the math on each page to make a link to a page that would query

SELECT * FROM newbie LIMIT 10,10

[cvincent]

Going along with what michael said, have a variable $offset that starts at 0. Issue the query "SELECT * FROM table LIMIT $offset,10" ,then increment it "$offset = $offset + 10", then place a link at the bottom "<A HREF="page.php?offset=$offset...">" and thats it.

-Chris

[Anon]

Thanks for the help! It works great..

[Anon]

come on man, they got to learn SOMETHING on their own! 🙂