Re: help with mySQL and ORDER BY
From: Jochen Daum (jochen.daum_at_cans.co.nz)
Date: 02/22/04
- Next message: Garrett Albright: "GD - Getting width of image resource in memory?"
- Previous message: LRW: "help with mySQL and ORDER BY"
- In reply to: LRW: "help with mySQL and ORDER BY"
- Next in thread: LRW: "Re: help with mySQL and ORDER BY"
- Reply: LRW: "Re: help with mySQL and ORDER BY"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 23 Feb 2004 10:19:25 +1300
Hi !
On Sun, 22 Feb 2004 21:19:20 GMT, "LRW" <druid@NOSPAHMcelticbear.com>
wrote:
>I have a table in a mySQL database that has 56 fields: 01, 02, 03, 04, etc
>up to 56.
>Each field has only 1 record in it. They get changed, updated, constantly,
>but always remaining one record.
>
>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.)
>
>Did that make sense?
>
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.
Jochen
-- Jochen Daum - Cabletalk Group Ltd. PHP DB Edit Toolkit -- PHP scripts for building database editing interfaces. http://sourceforge.net/projects/phpdbedittk/
- Next message: Garrett Albright: "GD - Getting width of image resource in memory?"
- Previous message: LRW: "help with mySQL and ORDER BY"
- In reply to: LRW: "help with mySQL and ORDER BY"
- Next in thread: LRW: "Re: help with mySQL and ORDER BY"
- Reply: LRW: "Re: help with mySQL and ORDER BY"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
