4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Selecting Latest 10 Articles but Not First Article
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
Justin
4WebHelp Addict
4WebHelp Addict


Joined: 07 Jan 2002
Posts: 1060

PostPosted: Sun Jun 08, 2003 12:59 pm (14 years, 4 months ago) Reply with QuoteBack to Top

Hi,

I am using the current line of PHP to pull the latest 10 article headlines out of my database containing them :

Code:
@$outcome=mysql_query("SELECT * FROM articles ORDER BY adate DESC,atime DESC LIMIT 10");


What I want to do however, is not pull the latest article out of the DB, I want to pull the next ten AFTER the latest article, I can't remember the code you use for this, anyone can help?

Thanks
OfflineView User's ProfileFind all posts by JustinSend Personal MessageSend email
Justin
4WebHelp Addict
4WebHelp Addict


Joined: 07 Jan 2002
Posts: 1060

PostPosted: Sun Jun 08, 2003 1:37 pm (14 years, 4 months ago) Reply with QuoteBack to Top

It's okay, worked out how to do it :

Code:
@$outcome=mysql_query("SELECT * FROM articles ORDER BY adate DESC,atime DESC LIMIT 1,10");
OfflineView User's ProfileFind all posts by JustinSend Personal MessageSend email
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.044349 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme