|
|
Posted by The Natural Philosopher on 10/07/07 17:43
Jerry Stuckle wrote:
> The Natural Philosopher wrote:
>> 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.
>
> And why reinvent the wheel?
>
Because you didn't know there was a wheel already invented?
Because it is made out of materials you don't have to hand?
Because you LIKE inventing wheels?
Because none of the wheels immediatetly to hand fit your wagon?
I could go on..
Navigation:
[Reply to this message]
|