Nothadoth Posted August 14, 2006 Share Posted August 14, 2006 Ok im scripting a shop. And i'm confused for a script.Basically it's a phone shop, and I have a section that shows the latest phone. Thats easy, order by id desc limit 1 right?But the person i'm doing the shop for also wants (aswell as the latest phone) the next latest 4 phones (so 2nd newest, 3rd newest etc. to 5th newest).Is there anyway to do this?So I want to ignore the newest entry in the database but show the next 4 newest.Thank you Link to comment https://forums.phpfreaks.com/topic/17516-looking-for-a-code-lastest-4-but-1-from-a-database/ Share on other sites More sharing options...
shocker-z Posted August 14, 2006 Share Posted August 14, 2006 I beleave this SQL should workselect * from table limit 4 offset 1never used offset myself tho so you will need to just try it :0RegardsLiam Link to comment https://forums.phpfreaks.com/topic/17516-looking-for-a-code-lastest-4-but-1-from-a-database/#findComment-74544 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.