limiting results per page?

[cleansedbb]

Hello all, I have a mysql dbase with about 3000+ entries
when I do a query it'll give me all the results. I want to limit to a php page only about 100-300 results per page.

not sure how to code this offhand but thinking to put the results into a file then parse the file into several files?

but I think I'm making to much work for myself.

Thanks In Advance!

[devinemke]

the answer to your question lies within the question itself:

SELECT * FROM table LIMIT 100

[cleansedbb]

well I dont want to limit only to 100 results. I want all 3000 but only want 100 per page. I think I'm going to add a counter on the results and when it hits 100 then start another page. just thought of it after posting.

[rachel2004]

Use LIMIT clause with your SELECT statement to limit the number of records to return at one time.

SELECT column1, column2 FROM table
LIMIT 0, 5;

The above SQL statement would limit the matches to your query to the first 5 records.

If you are interested in combining this into a PHP script, phpfreaks.com has a pretty good article. Here you go:

http://www.phpfreaks.com/tutorials/73/0.php

[rachel2004]

Originally posted by cleansedbb
I want all 3000 but only want 100 per page.

In that case, definitely look at the link I gave you.

[cleansedbb]

ah very helpful. thank you very much