|
|
Posted by The Natural Philosopher on 10/07/07 09:10
Rik Wasmus wrote:
> On Sun, 07 Oct 2007 00:20:12 +0200, Shelly <sheldonlg@asap-consult.com>
> wrote:
>> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>> news:QI6dnSmjxJezY5ranZ2dnUVZ_v_inZ2d@comcast.com...
>>> Colleen wrote:
>>>> I'm trying to find out if there's a query/function similar to the RANK
>>>> function in Excel.
>>>> What I want to be able to do is take a list of dates from a particular
>>>> table field, and be able to rank each record in the order within which
>>>> in falls in those range of dates, because records are not always
>>>> entered in chronological order.
>>>> So, from this "ranking" query (that would generate the result $rank),
>>>> I want to be able to say:
>>>> echo "$casualtyID is the number $rank casualty to die in the current
>>>
>>> Next time, please post your SQL questions to a MySQL newsgroup.
>>
>> This was actually both an SQL and a php question.
>>
>
> Euhm, how is PHP involved again?
Well it could have been: You could have done the sorting in php instead
of MySQL.
Navigation:
[Reply to this message]
|