[snip] I have a randomly ordered table. And I want to SELECT that table by ORDERing it in specific row, and when I'm done I want to find out numeric position of a raw where the first raw is 1, second is 2 etc.
Of course I could iterate over each row. But I want to do it for a specific raw only. Any ideas? [/snip] Can you show us a snippet of the table in question? It would be much easier. Jay sql,query --------------------------------------------------------------------- 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
