July 23rd, 2000, 05:30 PM
You guys may have already solved this already, but i just happened upon the question. there is a mysql function that will format the date/time column however you want it...
so, for your format, you'd have
select date_format(date,"<b>d/m/y</b> h:i p") as fdate from body order by fdate desc;
select date_format(date,"<b>d/m/y</b> H:i") as fdate from body order by fdate desc;
for 24 hour time (military)
just my $0.02..
July 24th, 2000, 10:14 AM
its not working xactly correctly
the top entry dosen't have the 2nd or 3rd field inputted
hense why i posted above :P