|
|
Posted by Shelly on 10/07/07 03:41
"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:du2dnUdgBowD2JXanZ2dnUVZ_oLinZ2d@comcast.com...
> 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.
Temper, temper. Easy now. No need to let your blood boil over what amounts
to trivialities.
>
> 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.
Nothing. That line is pure SQL.
> Or, where you had ANY PHP code in your answer.
Look above. You get a resource from executing the query. If you don't
agree that the reading the fields from each row of the result resource
obtained from the query, or the continuous looping through that set till
exhausted, or the output of each of these rows as html, is php, then we will
simply have to agree to disagree.
Shelly
Navigation:
[Reply to this message]
|