limiting display from mySQL database!!

[skmalla]

Hi,

I'm trying to display information from the database but want to display only 10 results/page instead of all the results entered in the database.
Similarly for next page only 10 results should be displayed.....
How can I pass on this value displaying information with a limit.

Thank you for your answer, priorly.

[jc94062]

SELECT * FROM tablename LIMIT 0, 10

[origo]

Read the artivle by Rod Kreisler here on PHPBuilder: http://www.phpbuilder.com/columns/rod20000221.php3

[Anon]

thanks