How to make the result of query in small numbered links, which has next and previous

Posted by gafow on June 1, 2008, 8:37 am

Please log in for more thread options

$results = mysql_query($query);
con_query($result);
while($pages = mysql_fetch_array($result)){
show/hide quoted text
}
}

$pages[1-300] -pages

to make links

show/hide quoted text

Thank you very much

Posted by Curtis on June 1, 2008, 9:17 am

Please log in for more thread options

gafow wrote:
show/hide quoted text

When I first started PHP, I had trouble on this issue, too, but only
because I didn't know it was called pagination, so it was a bit hard
for me to search for the topic.

Try googling: "php pagination" to see what you find.

--
Curtis

Posted by Jerry Stuckle on June 1, 2008, 9:24 am

Please log in for more thread options

gafow wrote:
show/hide quoted text

Figure out how many items you want per page. Now get a count of the
number of items which would be retrieved and divide by the number of
items per page. This will give you the number of pages (after
accounting for a possible partial page, of course).

For instance - if you want 10 items per page, the easiest way would be:

$numpages = intval(($itemcount + 9) / 10);

Now figure out what page you're on, and fetch the entries from the
database just for that page.

And if you need help with the SQL end, check comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================