Sort Date Problem

DigitalExpl0it

Im having a little problem date sorting.

basicly I have some dates in a mysql database with other information, thing is I have it sorted by the lastest date (or post) problem is its not sorting it correctly

$sql = "SELECT * FROM AO_ForumTopics WHERE FForum = '".$did."' ORDER BY sorttime DESC LIMIT $offset2, $limit";

the post page inserts this intot he date field

$sorttime = date("y-m-j g:i a");

is there a better way to do this?

basicly im getting this with my sort mix up

03-09-6 4:14 pm

03-09-6 4:12 pm

03-09-12 12:58 pm

03-09-11 11:58 pm

insectis

I'm thinking it's because you're using date("y-m-j") instead of date("y-m-d"). Using "j" truncates the leading 0, therefore on the sort, php is interpreting 03-09-6 as 03-09-60, making it come after 03-09-12. Try using a "d" instead.

insectis

superwormy

Use date ("Y-m-d") or date ("Y-m-d h:i:s") if you need dates that you can sort by. Other formats will not sort correctly.

But really, you should just be using a MySQL DATETIME fieldtype anyway too.

superwormy

A timestamp, which is the number of seconds since the Unix epoch ( sometime in 1970 ) may be another good option instead of a formatted date. You can always chagne it to a formatted date later with PHPs date() function.