Printable View
My mySQL database table has around 200+ tables and it's doing this weird flashy thing as the page is being generated. I don't know if that's because my code is terrible or if it's just too many records to display on one page.
How can I limit the number of records to, say, 25 per page and have back and next buttons generated?
Use "LIMIT" in your SQL query. "SELECT * From table LIMIT 5, 50" Which means (unless I have the 5 and 50 backwards) "Show only 5 records starting at 50."
will that automatically display next and back buttons or just display 5 records and I have to figure out the rest?
You're going to have to figure it out, but it's not that hard.
Number of pages needed = ceil(mysql_num_rows() / 5)
Then just keep track of the current page and the starting number.
You're going to have to do it yourself, but it's not that hard.
Just keep track of the current page. You can get the total number of needed page by doing:
I'm sure there's examples of it somewhere.PHP Code:ceil(mysql_num_rows($something)) / 5;
heh you have it backwards.Quote:
Originally posted by The Hobo
Use "LIMIT" in your SQL query. "SELECT * From table LIMIT 5, 50" Which means (unless I have the 5 and 50 backwards) "Show only 5 records starting at 50."
select * from table LIMIT 5,10; # Retrieve rows 6-15
LIMIT (offset,) (rows)
bah, I figured as much :p