I'm trying to sort by the date for some mysql results... and in the table, the date field is "date" format, so the rows have like, 2009-3-5...
however when I sort by the date... it doesn't work right. I'm guessing PHP is treating it as a math problem in my query. How can I fix this? I've tried quotes around date. Any ideas?
thanks