Hi guys. I wanted to make a blog but I'm really really stuck with an issue. I want to make a blog script (much like wordpress).
My SQL table has the columns: post_title (char), post_content (char) and post_comments_number (integer - gets the number of comments for each blog post).
Now I want to display the posts on two pages: posts with high number of comments (>30) and posts with low number of comments (<=30). I want to display the posts just like they are displayed on wordpress but the problem is I don't know how to do that, mostly when it comes to display the posts on multiple pages, 10 posts on each page.
Shortly: I want to display 10 posts with 30+ comments on the first page, the next 10 posts on the 2nd page and so on. How do I do that ? I think my logic fails because I don't know how to determine what was the latest post on the first page, so I can grab the next following posts on the following page.
Any help with that ?