PDA

View Full Version : MYSQL display results


Rayden
07-18-06, 09:53 AM
I have problem with sorting results could you help me debug this:

"SELECT p.*,c.id as catid FROM mypages p,mycategories c WHERE (p.category = $value OR p.category = $value2 OR p.category=$c ) AND p.accepted = 'y' AND p.globalpaid='1' AND p.category=c.id ORDER BY p.title DESC LIMIT 0,10"
well the results for these give me this:

eerer
dsat
dsawr
wsltd
ddes

I wonder why is does not give it in title order...I think it has to use LEFT or GROUP BY but I don't know how to do this