another pagination problem

I noticed the thread on pagination here just after posting to mysql. But I am using php/mysql.... ;-) I have some rather complicated ordering problems: 1. need to order by 2 fields title, sub_title 2. need to display 10 items per page (hundreds, if not 1000s or pages) 3. order by ASC or DESC makes not difference when ordering by 2 fields 4. when ordering by title, results are totally different for ASC & DESC; not the same data at all (Is the ordering done on the entire db? ) 5. those funny little dingles over foreign language characters refuse to follow our normal ordering rules; how do we do this? 6. The pagination and ordering syntax is correct & working with no errors; I've double checked on commandline. 7. At worst, I'll have to leave it at ASC and let visitors p&m; don't see a simple solution. Or am I wrong? -- Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." ------------------------------------------------------------- Phil Jourdan --- pj@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php