delphi123 Posted November 27, 2007 Share Posted November 27, 2007 Hi, I've got the following code: $query = ("SELECT news_id, category, title, text, img_url, linkto, DATE_FORMAT(date,'%d %M, %Y') as sd FROM news_posts ORDER BY date DESC LIMIT 4") or DIE ("Can't retrieve"); showing the latest four posts by date. Elsewhere in the site I'd like to show the next four (ie posts 5,6,7,8 ) Can anyone show me how my SQL can be modified to do this? Link to comment https://forums.phpfreaks.com/topic/79096-solved-show-records-5-8-inclusive/ Share on other sites More sharing options...
~n[EO]n~ Posted November 27, 2007 Share Posted November 27, 2007 LIMIT 4, 5 will fetch 4 records starting from the 5th row Link to comment https://forums.phpfreaks.com/topic/79096-solved-show-records-5-8-inclusive/#findComment-400314 Share on other sites More sharing options...
delphi123 Posted November 27, 2007 Author Share Posted November 27, 2007 super! Link to comment https://forums.phpfreaks.com/topic/79096-solved-show-records-5-8-inclusive/#findComment-400316 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.