MySQL Forums
Forum List  »  PHP

retrieving the row position of a result in specific sort of the table
Posted by: Adult SEO
Date: September 11, 2006 10:00AM

Hi!

I am also looking for a solution for this.

I want to query for a row, and know the position of it in a specific sortion.

E.g. SELECT * FROM table WHERE id='102'

And then know the position in this query:

SELECT * FROM table ORDER BY 'title'

Please Help!

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.