|
|
Posted by Jerry Stuckle on 10/07/07 04:24
Shelly wrote:
> "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
>
>
I repeat. Where in "ORDER BY deathdate" has anything to do with PHP? I
don't see ANY sql in the PHP manual, for instance.
And where is the PHP code in your answer?
Or can't you tell the difference between SQL and PHP?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|