Matt
04-02-2002, 01:05 PM
I have on my site homepage a section where it displays the next episode of "Dark Angel" that is going to air, along with the time and a link to the episodes info in the episode guide.
The problem is that its stored on a US server, and I want to make it so that the time is offset by 5 hours so that the next episode shows up as soon as the current one is over. So with Dark Angel finishing at 10PM over here, at 10PM I want it to switch to the next episode in the table, rather than switching at 2am when its 10PM in the US.
I managed to do this before somewhere but I deleted the damn file the other day and all I remember is I used DATE_ADD() to add on the offset amount of hours to the time so that it would change at the right time.
"SELECT *, DATE_FORMAT(start,'%b-%d-%Y') as startdate, TIME_FORMAT(start,'%h:%i %p') as starttime, DATE_ADD(start, INTERVAL 5 HOUR) FROM ep_airdates WHERE ((stationID='1') AND (start > NOW())) ORDER BY start ASC LIMIT 1"
That is the SQL where start is the start date and time (DATETIME)
Can anyone tell me what I am doing wrong please :(
Matt
The problem is that its stored on a US server, and I want to make it so that the time is offset by 5 hours so that the next episode shows up as soon as the current one is over. So with Dark Angel finishing at 10PM over here, at 10PM I want it to switch to the next episode in the table, rather than switching at 2am when its 10PM in the US.
I managed to do this before somewhere but I deleted the damn file the other day and all I remember is I used DATE_ADD() to add on the offset amount of hours to the time so that it would change at the right time.
"SELECT *, DATE_FORMAT(start,'%b-%d-%Y') as startdate, TIME_FORMAT(start,'%h:%i %p') as starttime, DATE_ADD(start, INTERVAL 5 HOUR) FROM ep_airdates WHERE ((stationID='1') AND (start > NOW())) ORDER BY start ASC LIMIT 1"
That is the SQL where start is the start date and time (DATETIME)
Can anyone tell me what I am doing wrong please :(
Matt