2 replies to this topic

[M24KPM]

I have a tutorial cataloging system, and I use a mySQL table to show the content in my site. On my main tutorials.php page I have it showing the most recent tutorials, is there a way to make it so it only displays 20 of them and no more than the 20 most recent?

Not sure if this will help but here is what is used to show how to display the tutorials...

$query = "SELECT * FROM tutorials ORDER BY id DESC ";

-M24KPM

[Trix06]

Yes you can show the 20 most recent, its simple to do this you use a limit clause like this

$query = "SELECT * FROM tutorials ORDER BY id DESC LIMIT 20";

Somthing like that, if thats not correct someone should be able to help, or type limit sql in google and you will sure find the answer your after.

[M24KPM]

thanks a ton guys! still kinda new to the whole mySQL things. Once again thanks guys!