> How do you find what position a value is in a larger query's result?
Well, if you put some sorting to your search, you will know the position of your item by the count of the loop you are using to extract the data. You use limit to return a max number of items, and keep a tab of where your limit starts. Let's say you want to display only 10 pictures (using php variables for the example): $startlimit=0; the query: select * order by tstamp limit $startlimit, 10 if you want to see the next set of picture $startlimit=10 When someone clicks on a picture, just send the $startlimit variable over and it will come back to the same stack. ------------------------------------------------------- --------------------------------------------------------------------- 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
