I am writing a site where I will have a news feed of updates on the front page. I have a table that will store the posts. Its fields are post_id, topic, body, and dateposted. I would like for it to search through the table and get the ten latest posts. What would be the easiest way to do this?
fuggles
0
Junior Poster in Training
Recommended Answers
Jump to Postselect post_id, topic,body, dateposted order by dateposted desc limit 0,10
All 2 Replies
urtrivedi
276
Nearly a Posting Virtuoso
select post_id, topic,body, dateposted order by dateposted desc limit 0,10
KMon
0
Newbie Poster
LIMIT 0,10
That totally helped. Thanks!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.