Jump to content

Archived

This topic is now archived and is closed to further replies.

Nothadoth

Looking for a code: lastest 4 but 1 from a database

Recommended Posts

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

Share this post


Link to post
Share on other sites
I beleave this SQL should work

select * from table limit 4 offset 1

never used offset myself tho so you will need to just try it :0


Regards
Liam

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.