multiple order by not working in MySQL

[nemesis_256]

I'm trying to do a query with two columns for the order by, but the second column is being ignored. I've tried adding asc and desc to it but there's no difference, it's as if the competitorID isn't even there. Any ideas?

select * from table where clientID = 15 order by dateAdded desc, competitorID;

[chazzy]

the second column is only used when r1.dateAdded = r2.dateAdded. What type is the dateAdded column (from the definition of the database, varchar, date, etc). what precision is it?