From: Gavin Towey (gtoweyffn.com)
Date: Fri Jul 17 2009 - 15:57:00 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

From your description of your problem, it's very difficult to understand what you're doing and what results you're trying to get.

Making some assumtions, I think you might need to use a technique described in this link to get the results you want: http://jan.kneschke.de/projects/mysql/groupwise-max

Otherwise, for better help:
1) Show us the exact query you are doing, and the structure of the tables.
2) Show a small sample data set if possible
3) Show what the result set you want would look like.

Regards,
Gavin Towey

-----Original Message-----
From: PJ [mailto:af.gourmetvideotron.ca]
Sent: Friday, July 17, 2009 8:07 AM
To: MySql
Subject: ordering search results

Can't find anything on the web that deals with my problem(s).
I have to display thousands of book listings by title, sub_title with 10
books per page. The php/mysql code works fine - except:
ASC or DESC does not change one iota.
I have checked by commandline and find that it is not working at all how
I would expect.
From commandline, using just title and switching between ASC & DESC give
totally different results rather than displaying the same data in
reverse order.
The display is, as mentioned above, 10 books per output page: so, from
what appears to me, the ordering seems to be done on the entire db & not
just on the search results (this is basically from a SELECT statement).
Furthermore, not all the data is in 1 table; authors, categories &
publishers are in separate tables because of 1 to many & many to 1
relationships.
Still another problem is the use of a number of foreign languages which
have those strange accent on many letters that do not order very well.
Now, that I have spewed out my problems, would it be possible that there
is someone out there who could suggest how to go about figuring this out?
Thanks in advance.

--
Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
-------------------------------------------------------------
Phil Jourdan --- pjptahhotep.com
   http://www.ptahhotep.com
   http://www.chiccantine.com/andypantry.php


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gtoweyffn.com


The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]