proud Posted January 13, 2007 Share Posted January 13, 2007 Hello, i have recently created a forum using php code, but the problem i suffer from is that all the messages are displayed in the first page. So if i want after a certain number of messages i.e(50)to put the rest in a second page ordered by descending what would be the php code for that?Thankyou .... Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted January 13, 2007 Share Posted January 13, 2007 This is called pagination. Take a look at this tutorial here:http://www.phpfreaks.com/tutorials/147/0.php Quote Link to comment Share on other sites More sharing options...
scotmcc Posted January 13, 2007 Share Posted January 13, 2007 Without any more information I'd simply suggest that you look up the "limit" command if you are using MySQL. If you do, you will find that you can use a query like this:[code]SELECT * FROM [TABLE] ORDER BY [FIELD] DESC LIMIT 1, 50[/code]I think this syntax is correct, but you will have to check it out :)Scot McConnaughay Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.