ansaurus

Question

TV Guide script - getting current date programmes to show

Answer 1

A:

I don't know, but I would guess there's something strange about the way that you are storing your date and time in the airdate column. Try running a query like this so you can do the same comparison you're asking the database to do:

select now(), airdate from mediumonair where episode = 'Episode'

Don Kirkby 2010-05-17 18:38:17

The airdate column is stored as DATETIME, so I don't understand why this happens.

whitstone86 2010-05-17 18:41:55

You don't understand why what happens, @whitstone86 ? What does the result look like when you run the query I suggested?

Don Kirkby 2010-05-17 18:46:25

I've got a blank area, no results.

whitstone86 2010-05-17 18:50:16

It could be that the database server is storing the DATETIME based on Coordinated Universal Time (UTC), rather than local time. If there's enough difference, that would explain why the first row was missing from the retrieval.

Gilbert Le Blanc 2010-05-17 18:54:21

http://i39.tinypic.com/mazec0.jpg shows an example of it

whitstone86 2010-05-17 18:57:32

Please can someone help?

whitstone86 2010-05-17 21:17:24

I suggest you look directly in the database to see how the airdate is stored. Do you have phpMyAdmin or some other database tool that can directly query your database? If you can't get that working, then using var_dump() to look at the query results would be the next best thing.

Don Kirkby 2010-05-17 21:33:13

I do use phpMyAdmin for it, and it's stored as DATETIME.Tried setting timezone but had no luck with it.Will try var_dump() and let you know if it works!

whitstone86 2010-05-18 09:57:59

Try using phpMyAdmin to run the query I posted. Then you can compare the stored airdate and the now() function yourself.

Don Kirkby 2010-05-19 05:38:09

ansaurus

tags:

views:

answers:

TV Guide script - getting current date programmes to show

related questions