Re: MySQL sorting problem
| From: | John S. Huggins | Date: | Tue, 06 Nov 2001 12:16:07 +0000 |
| Subject: | Re: MySQL sorting problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-73579@lists.php.net to get a copy of this message | ||
On Tue, 6 Nov 2001, De Necker Henri wrote:
>-Hi there
>-
>- S1.1
>- S1.2 ....
>- S1.21
>- S1.22 ...
>- S1.3
>- S1.4
>- S2.1
>- S2.2 ....
>-
>-Is there different way I can list them or safe the in the db.
>-Any help will be appreciated
>-Thank u!
I suggest splitting up the value "S1.3" into three fields:
Field1 = S
Field2 = 1
Field3 = 3
This might seem wasteful and indeed might be, but you will have complete
total control over your sorts.
"SELECT * FROM tablename ORDER BY ASC Field1, ASC Field2, ASC Field3"
... or something like this.
Good luck.
**************************************
John Huggins
VANet
703-912-6453
703-912-4831 fax
jhuggins@va.net
http://www.va.net/
**************************************