[eluser]Thorpe Obazee[/eluser]
[quote author="newbie boy" date="1246010603"]i tried saving it in an military format of time where in AM is selected add 00 and for PM where it adds 1200 on the time selected...
like if 7:00 AM(+00) == 0700;
and if 7:00 PM(+1200) == 1900;
but my problem now is when 12:00 AM or PM is selected will output opposite data...
anyone there have a best solution in saving time to the database?
thanks...[/quote]
I'm still not sure how you're lost. Did you try strtotime()?
You could always use TIMESTAMP or DATETIME to store time on a database
EDIT: Read that you're already using timestamp