Hi.
Because you said, Rene, that you already know how to sort according to
one of both criteria, I presume ordering the series column is not the
problem (e.g. because it is an enum or something alike).
Then the solution would simply be to do something like
SELECT * FROM my_table WHERE ... ORDER BY series, price
I.e. simply list the order criteria which work seperately in the ORDER
BY clause. If this is not appliable, please elaborate.
Btw, it is *much* easier to help if you had quoted a (partial) working
query (which include table and column names and so on). Also, how the
series are stored would have been of interest, because this will
influence how the ordering is specified.
Also, I do not understand why you put emphasis on the fact that the
series is sorted in an unusual way if you later say that you already
know how to order by it?! Is this relevant to the problem at all?
Bye,
Benjamin.
On Tue, Dec 04, 2001 at 12:36:34AM +0200, [EMAIL PROTECTED] wrote:
>
> 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
[...]
--
[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
