Hi all, let's figure we have one big database table ~1mln rows.
I can easly to collect needed data from this table with query: SELECT id,title,cdate FROM bigtable WHERE active ORDER BY cdate ASC, id ASC LIMIT 300,100 So i get needed rows to display. i can make easly with page numbers to display all data. What i need? I know id of data in bigtable so i wanna know in what place will be record with query (SELECT id,title,cdate FROM bigtable WHERE active ORDER BY cdate ASC, id ASC) example result of query : id|title 00: 1 |name1 01: 12|name2 02: 6|name15 03: 42|name3 04: 25|nameX 05: 35|name4 ... I know id 42, and i want to get result 3, (if id=25, result would be 4) i can't download all data to php script, and find record after query. Because it's slow, and can take big count of RAM in server. Why I need that? 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 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 It's possible to do in mysql? Sorry for bad english. -- 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]
