Re: help with mySQL and ORDER BY

From: Jochen Daum (jochen.daum_at_cans.co.nz)
Date: 02/22/04 

Date: Mon, 23 Feb 2004 11:39:07 +1300

Hi !

On Sun, 22 Feb 2004 22:34:54 GMT, "LRW" <druid@NOSPAHMcelticbear.com>
wrote:

>"Jochen Daum" <jochen.daum@cans.co.nz> wrote in message
>news:k57i301abc9hs61k5o10fet0iblrnvn0g6@4ax.com...
>> Hi !
>>
>> On Sun, 22 Feb 2004 21:19:20 GMT, "LRW" <druid@NOSPAHMcelticbear.com>
>> wrote:
>>
>> >Is there a way to do a SELECT * on the table, and then order them in ASC
>or
>> >DESC by the fields as opposed to the records in a field? (They're all
>> >numeric fields.)
>> >
>> I understand what you want, but a database doesn't suppport that. You
>> have to use 56 records, which is a better data model anyway.
>>
>
>Hrrmm. Is there some way to be able to sort/order the results by numeric
>value? Highest to lowest?
>Something while making the WHILE array perhaps?
>I don't really know how to begin looking to do something like that. If it's
>possible, a simple pointer, the name of the process, is all I need and I'll
>go look into it.

www.php.net, search for array_sort or array_ksort or array_usort

>I just want to be able to dynamically sort the results on a Webpage in
>realtime. =/

realtime means with or without reload.

Jochen 

-- 
Jochen Daum - Cabletalk Group Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/

Relevant Pages

  • Re: PHP with MS SQL on Windows Box
    ... Must be tcp afaik. ... Jochen Daum - Cabletalk Group Ltd. ... PHP DB Edit Toolkit -- PHP scripts for building ... database editing interfaces. ...
    (comp.lang.php)
  • Re: ORDER BY Zip Code Distance
    ... problem was to find how many points from his database lay within x miles of ... "Jochen Daum" wrote in message ... The zip sort by distance works great ... > PHP DB Edit Toolkit -- PHP scripts for building ...
    (comp.lang.php)
  • Re: Need advice w/ table design
    ... >In a relational database, each table should conceptually represent one type ... So for a table representing computers, ... Jochen Daum - Cabletalk Group Ltd. ... PHP DB Edit Toolkit -- PHP scripts for building ...
    (microsoft.public.sqlserver.programming)
  • Re: Handle a transaction through a script reload ?
    ... >database, i don't want them to run a mysql command or things like that... ... Jochen Daum - CANS Ltd. ... PHP DB Edit Toolkit -- PHP scripts for building ...
    (comp.lang.php)
  • Re: genric add/edit/delete for MySQL?
    ... >looking for some generic database access pages for doing adds, edits, ... >can just change connection string, database fields, etc. ... Jochen Daum - Cabletalk Group Ltd. ... PHP DB Edit Toolkit -- PHP scripts for building ...
    (comp.lang.php)