Re: FN-FORUM MySQL query

date posted 29th January 2003 15:54

Is this what you mean? If you've got a table called 'humungoustable'
that has a field called 'something' in it, and you want to find where in
the list a record lies that has 'something' set to 500, you could do
this, and it doesn't require a pre-ordered table as it does a sort in
the query:

SELECT COUNT(*) FROM humungoustable WHERE somethingI'm having problems writing a SQL query that extracts the position of
>a record in a sorted table without actually fetching the entire list
>of records (potentially very large list) and doing some nasty
>processor intensive looping in PHP.
>
>Anyone know a quick and dirty way of doing this, or will I have to do
>lots of processing in PHP to calculate positions?
>
>---------------------------
>Richard Watt Website Design
>site : http://www.rwatt.co.uk
>email : [EMAIL REMOVED]
>phone : (0131) 466 0700
>fax : (0131) 466 1813
>
>