Vaidas Zilionis wrote: [...]
Example items are displayed 100 in page, and i display 20 pages numbers 1 ... 4[5] 6 ....x doomain.con/items.php?page=5
and i get all result here with limit 400,100
Yes, with PHP it would be something like this:
$items_per_page = 100; $limit_clause = ((int)$page-1)*$items_per_page.','.$items_per_page;
If i use it
doomain.con/items.php?showid=45 (example he is in 7 page)
i want to see same table with page numbers and ect. And record must be in 7 page. 1 ... 6 [7] 8 ....x
Why not just create your links like this:
doomain.con/items.php?showid=45&page=7
At this stage, when you create the link, you allready know what page you are on. Why waste time and try to calculate it again?
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
