Forum Moderators: coopster

Message Too Old, No Replies

need Mysql help please!

how retrieve only a certain amount of data from mysql

         

PokeTech

2:54 pm on Apr 5, 2008 (gmt 0)

10+ Year Member



Well I have everything working but I have like 20+ entries but I only what to retrieve 5 of them and I want them to be the newest entered ones in the database so its like this:

Wi-Fi Section!
NEW DOMAIN!
The New Layout!
Our Tool Bar!
Site update! - comics section.
Forum Updates!
Bit of a post layout update.
Some more updates today!
Bit of a forum upgrade.
Maps Section
Games Section!
Screen Shots
New Pages!
Long Day
TopSites!
Sorry...
To come...
Updates
Few updates today!
Updates
Few new updates
Fixes!
Maintenance
Site Release!
Few updates
New Layout
RPG Corner!
Rules

So those are kind of the titles. Thats what it looks like on the page after all the code. But I only what the ones that are in bold to be seen the other ones I don't even what to show up on the page.

Could anyone help?

BrunoDillen

3:07 pm on Apr 5, 2008 (gmt 0)

10+ Year Member



end your query with "ORDER by id DESC LIMIT 5" ?

PokeTech

3:36 pm on Apr 5, 2008 (gmt 0)

10+ Year Member



Thanks!

That was pretty simple...