Jump to content


Photo

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


  • Please log in to reply
1 reply to this topic

#1 Nothadoth

Nothadoth
  • Members
  • PipPipPip
  • Advanced Member
  • 119 posts

Posted 14 August 2006 - 03:27 PM

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

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 14 August 2006 - 03:59 PM

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
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users