Ok, i'm getting a bit annoyed with this. All I want to do is store a bunch of simple times in a MySQL database and then display them in order. I need 4:00 PM to come after 8:00 AM. I'll be entering the times manually into the database. I don't want 4:00 to be 16:00. I know that would be easy. I don't need dates or anything like that. I tried storing them as varchar in the format 16,0,0,0,0,0. That worked fine when for the hour with mktime() and the format ('H:i A') but the minutes (i) part of that format would grab the current minutes instead of what was contained inside the string. Lemme back up.
$time = '16,0,0,0,0,0';
$time_conv = mktime($time);
$time_disp = date('g:i A', $time_conv);
This code display the hour correctly, 4, and the right time of day, PM. But instead of 00 for the minutes, it displays the current minutes. So why does it know to use the 16 from the provided string for the hour and time of day but doesn't grab the minutes from the string? Hopefully I haven't lost everyone with my explanation. Thanks
