Originally Posted by minkoko
Thanks mate ,now i see how to format the date for your kindness
and i just have one question about the time
can i formate the time like this 9:00 AM to 10:35 PM
Really thanks sunfighter
Those are the same format. 9:00 AM = 10:35 PM when it comes to the display format. MySQL uses a 24 hour clock, so display wise you can use PHP to interpret it as you see fit. Since you are using a datetime type in MySQL, php can take that an convert it easily with the datetime class.
$dt = new DateTime($record['datetime']);
print $dt->format('F j Y g:i A'); // January 5 2013 12:27 PM