943,587 Members | Top Members by Rank

Web Development > PHP > Displaying News Articles
Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 1860
  • PHP RSS
Permalink
Jul 25th, 2005
0

Displaying News Articles

Expand Post »
I've been thinking for awhile now that I should code a nice news system, and I have the structure all figured out, but what stumped me was: How do you display the articles with the latest first?

I would set up a MySQL table with columns Title, Date&Time, Body, ID, Author, Source (not in that order). How would I then go about retrieving them and listing them in reverse order?
Similar Threads
Reputation Points: 14
Solved Threads: 0
Light Poster
Sp!ke is offline Offline
45 posts
since Jul 2005
Permalink
Jul 26th, 2005
0

Re: Displaying News Articles

Use ORDER BY command in your database query.
If you not sure about SQL commands, do your search on google or yahoo.
Reputation Points: 10
Solved Threads: 7
Posting Whiz in Training
zippee is offline Offline
294 posts
since Jan 2005
Permalink
Jul 26th, 2005
1

Re: Displaying News Articles

This is the query I use on my CMS system:
[PHP]$query="SELECT * FROM news ORDER BY id DESC LIMIT 5";[/PHP]

ORDER BY id DESC will get the latest article first (the article with the highest id).
LIMIT 5 is a useful thing - it gets only the amount of articles you specify. If you didn't have this, all your articles would show on one page, and if there are lots of posts, you will end up with a massive page.
Reputation Points: 11
Solved Threads: 0
Light Poster
alex_extreme is offline Offline
27 posts
since Mar 2005
Permalink
Jul 26th, 2005
0

Re: Displaying News Articles

Ahh, that helps greatly. Thanks!
Reputation Points: 14
Solved Threads: 0
Light Poster
Sp!ke is offline Offline
45 posts
since Jul 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: Arrays
Next Thread in PHP Forum Timeline: Generating .doc reports





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC