Hi.
On Mon, Dec 03, 2001 at 06:16:26PM -0700, [EMAIL PROTECTED] wrote:
> The problem is, if I sort by the price field, the ordering of the series
> gets mixed up (since low-end models in higher-end series cost more than
> some higher-end models in lower-end series (confused?? I am :-) If I
> just sort by series, I don't get the prices in order within each series
> (big problem).
How do you sort by series (if you don't care about price for a moment)?
[...]
> > I.e. simply list the order criteria which work seperately in the ORDER
> > BY clause. If this is not applicable, please elaborate.
[...]
> > Also, how the series are stored would have been of interest, because
> > this will influence how the ordering is specified.
I.e. is it an ENUM or VARCHAR column or a reference to another table?
If you have a hard time explaining it in words (I know I would have ;-),
you may want post some excerpt of your table scheme (created with
mysqldump)
> And if I sort by BOTH series and price, which is the logical thing
> to do, and which many people have kindly suggested (and which I have
> tried), well, it doesn't work, because the series must be sorted in
> a non-alphabetical way.
But how do you do it for the series alone, then? You said you have
that part working. Please show us the SQL query or PHP part of that
alone.
Bye,
Benjamin.
PS: not cross posted to PHP list.
--
[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
