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 Quote Link to comment 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 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.