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 .... Link to comment https://forums.phpfreaks.com/topic/34008-forum/ 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 Link to comment https://forums.phpfreaks.com/topic/34008-forum/#findComment-159855 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 Link to comment https://forums.phpfreaks.com/topic/34008-forum/#findComment-159856 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.