|
|
Posted by Jerry Stuckle on 10/07/07 13:45
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?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|