Hello Roger, Monday, May 9, 2005, 2:56:18 PM, you wrote:
Heh if i know page i would haven't problem. but i need to get also correct page with link doomain.con/items.php?showid=45 it can be anywhere! :) I making web application with data binding (IE stuff) data is loading very fast, can be 1000 and 1000000 of rows, it's not problem, and user interface with data loads very fast. if i use scroll, JS count's what possition is on row, and if needed loading data from server. But now i need to to simple trick, SelectRowWhereId(1525) script must now position of that row in database with same WHERE and ORDER. so i never know "page" number. :) RB> Vaidas Zilionis wrote: RB> [...] >> 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 RB> Yes, with PHP it would be something like this: RB> $items_per_page = 100; RB> $limit_clause = RB> ((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 RB> Why not just create your links like this: RB> doomain.con/items.php?showid=45&page=7 RB> At this stage, when you create the link, you allready know what page you RB> are on. Why waste time and try to calculate it again? -- -- Vaidas Žilionis Mobile: +370 616 91393 ICQ: 35174940 Website: www.zilionis.net Project: www.sitesupra-tools.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
