Short version: How do you find what position a value is in a larger query's result?
Long version: I have a thumbnail image viewing page that pages through search results using LIMIT page * page_size, page_size and that table does keep id's from all results but they are not always 1, 2, 3, 4, 5... often they are 1, 3, 6, 7, 9, etc.. in no special pattern but in order.. there is also an image id per each row that is not in order and again in no special pattern.. in cases where the user has clicked an image it uses the image id to view the image.. then when the user wants to return to browse mode it needs to figure out what page to return to. easy.. except they can also flip backwards and forward in the results in view mode so the page could change. So I need to find the page which I can do if I can find the id and it's position in the queries result. How exactly would I find the position in the results without dumping all results and using an external function. Something like "position = variable in array". *^*^*^* Michael McGlothlin <[EMAIL PROTECTED]> http://mlug.missouri.edu/~mogmios/projects/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
