Well I think mysql doesnt allow you to do this that simple as mysql
doesnt know how you want to sort it exactly. So my suggestion would be to
give a value to each series, eg. Baby = 1,
Genesis=2,Super=3,Predator=4,Millennium=5 and then order by series.
Cheers
Siim Einfeldt
> One more thing, very important: I want to specify the Series sort order,
> not alphabetically, but by a non-obvious way
> (Baby>Genesis>Super>Predator>Millennium)...
>
> ------
>
> I want to select about 25 rows from a table, and sort them by two
> criteria. First, by each row's Series field ("Baby", "Genesis", "Super",
> "Predator", "Millennium" are the various Series, and the order I'd like
> the rows in the array). Within each Series, I'd like the rows sorted by
> their Price field, ascending. For example:
>
> Baby $5
> Baby $10
> Baby $15
> Genesis $20
> Genesis $35
> Genesis $50
>
> ...and so on.
>
> Now, I know how to structure my MySQL Select statment such that the rows
> it pulls from the table will be either sorted by Price OR by Series, but
> not both, in the way I'd like. Does anyone know if it's possibly to do
> this in the Select statement itself? (I'd rather do it that way, than
> resort in PHP.)
>
> Thanks!
>
> ...Rene
>
> ---
> René Fournier
> [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
