|
|
Posted by Jerry Stuckle on 10/07/07 02:34
Shelly wrote:
> "Rik Wasmus" <luiheidsgoeroe@hotmail.com> wrote in message
> news:op.tzsyi5zq5bnjuv@metallium.lan...
>> 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?
>> --
>> Rik Wasmus
>
> After getting the results, the looping through each record in order to
> output the results.
>
>
Bullshit. You can't rationalize your way out of this one, Shelly.
The question was a SQL question, and the answer was a SQL answer.
Or, please tell me how "ORDER BY by deathdate" has ANYTHING to do with PHP.
Or, where you had ANY PHP code in your answer.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|