Re: help with mySQL and ORDER BY

From: LRW (druid_at_NOSPAHMcelticbear.com)
Date: 02/22/04


Date: Sun, 22 Feb 2004 22:34:54 GMT


"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.
I just want to be able to dynamically sort the results on a Webpage in
realtime. =/

Thanks!
Liam



Relevant Pages

  • Re: help with mySQL and ORDER BY
    ... >> I understand what you want, but a database doesn't suppport that. ... Jochen Daum - Cabletalk Group Ltd. ... PHP DB Edit Toolkit -- PHP scripts for building ...
    (comp.lang.php)
  • Re: Automated Form Validation?
    ... > before putting it into the database - even down to things like making sure ... > that numeric fields contain numeric data, ... What guarantee can you give that best practice ... then the validation rules aren't going to change. ...
    (comp.lang.php)
  • Re: How set default value
    ... Select this check box to have the program convert null values from the database to a 0 (for numeric fields) or a blank. ... To do this you could use a function such as COALSCE in SQL Server to control what is returned from the database. ... In the Default Settings Option dialog box and under the Reporting tab, ...
    (microsoft.public.vb.crystal)
  • Newbie auto enter question
    ... In my database there are 3 numeric fields, A, B and C, where field C = A-B. ... Prev by Date: ...
    (comp.databases.filemaker)
  • Re: update 500000 records with adodb.recordset resize the mdb from 140M to 2G
    ... the size of the database. ... The upper limit of a JET database is ... > text and numeric fields are updated. ...
    (microsoft.public.data.ado)