php blog

**kozmk** · 05-03-2008, 07:30 AM

hey guys,

I'm trying to script my own blog, but I have a problem.
On the homepage I got the script to show the last 5 post that have been made, but now I want to show "older" post so it I need a page that skips the first 5 post and shows the next 5 post. How can I get this info out of mysql ?

thanks

**nickohrn** · 05-03-2008, 09:54 AM

I think the following may be what you're looking for.

Code:

"SELECT * FROM post_table_name LIMIT 5 OFFSET 5"