List:General Discussion« Previous MessageNext Message »
From:Darryle Steplight Date:July 17 2009 7:58pm
Subject:Re: ordering search results
View as plain text  
You might have to change the collation you are currently using to one
that best match the language of those weird accents you are referring
too. That's part of the reason you may be getting unexpected results
with your ORDER BY statement. Also, can you show us your select
statements?

On Fri, Jul 17, 2009 at 11:06 AM, PJ<af.gourmet@stripped> wrote:
> 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 --- pj@stripped
>   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=1
>
>



-- 
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
A: Top-posting.
Q: What's the biggest scourge on plain text email discussions?
Thread
ordering search resultsPJ17 Jul
  • RE: ordering search resultsGavin Towey17 Jul
  • Re: ordering search resultsDarryle Steplight17 Jul
Re: ordering search resultsPJ17 Jul
  • RE: ordering search resultsGavin Towey18 Jul
  • RE: ordering search resultsGavin Towey18 Jul