[RESOLVED] Query is correct - result is not

[Kudose]

Hello all.

I have a query which is built of a dropdowns a user selects. When I display the string on the screen, everything looks perfect. When I get my results back, sorting doesnt really work -- it just moves things around but not like I want.

Check it out here: Click Here

I have the query printing -- the drop downs reflect the variables chosen.

Can MySQL not sort properly because the table isn't indexed?

Any help would be awesome. Thanks!

[jheitz]

Hi,

Your results look fine to me... You are ordering first by Year and then by Price, so it is normal that, out of 3 cars you get first the two with a 1994 year and then the one of 1996. The two from 1994 are ordered correctly by price which is what you requested.

On the other hand, indexes can never afect order clauses (nothing can, but a bug).

[Kudose]

Try listing in descending order please. The 1996 always stays at the bottom.

[jheitz]

The problem is that the SORT ORDER needs to be specified in EACH COLUMN. Therefore, your select should read like this:

SELECT * FROM listings WHERE status<='2' ORDER BY year ASC, price ASC

and not this:

SELECT * FROM listings WHERE status<='2' ORDER BY year, price ASC

[Kudose]

Makes sense. Thanks.