Time Zones with MySQL and PHP

[Trundle]

Hello,

Im wondering how I can save a time (which isnt right now) in the db, and convert it into other times (for example, 2:00pm -2h).

My problem is, when I count 2:00pm -2h i get 0:00, and when i do -3h i will get 23:00. How can i convert this time into am/pm. I just cant find any answer, would be nice if someone could help 🙂

[helz]

well is there might be a time thing on php.net... just checked didnt seem to have anything
if its always in 12 hour then this would/could/should work:

if (strpos($time,"pm")) {
   if ($newtime == "0:00pm") {
      $newtime = "12:00am";
   } elseif ($newtime == "13:00pm") {
      $newtime = "1:00am";
   }
} elseif (strpos($time,"am")) {
   if ($newtime == "0:00am") {
      $newtime = "12:00pm";
   } elseif ($newtime == "13:00am") {
      $newtime = "1:00pm";
   }
}

check through that to see if it helps

[Trundle]

Well thanks for the code, but the actual problem is actually more complex.

On my site (tournament site) hosts can set a time, with a sign up time (which they an choose, like 1h before the actual start etc.)

I have 4 fields in the MySQL Table, called TrnyStartH (hour), TrnyStartM (minute), TrnyWhen (am/pm) and TrnySignUp. each field gets set by a field on the page where you can set the Start Time.

Now I get the field TrnyStartH and count it minus with TrnySignUp. It works fine if its for example, 5h - 2 (sign up).
But if its 1h pm - 2 i will get a different result, i expect 11am but what i get is -23.

Heres the current code i use (easy one)

$TrnySignTime = $rows[TrnyStartH]+$rows[TrnySignTime];

Well, thats it. I dont know how to fix that problem, heres an example for the error: http://www.gc.page.it/tourney.php?tid=2

Thanks!

[helz]

hmm since it gives a minus number, maybe add 12 to it?

you might be able to cheat and remove the minus sign 🙂

str_replace("-","",$time);

[Trundle]

Nice idea, but now it says -11 :S

[helz]

try deleting the minus sign, like in my edited post above