This really is a part of my TV guide script:

       //Connect to the database
   mysql_connect("localhost","root","PASSWORD");
   //Select DB
   mysql_select_db("mytvguide");

   //Select only results for today and future
   $result = mysql_query("SELECT programme, channel, episode, airdate, expiration, setreminder FROM mediumonair where airdate >= now()");

The episodes appear, so you will find no issues there. However, it's obtaining the database to locate data this is the problem.

Basically give a record for any programme that airs today this will show:

Medium   showing on TV4   8:30pm    "Episode"    Set Reminder
Medium  showing on TV4  May 18th - 6:25pm  "Episode 2"  Set Reminder
Medium  showing on TV4  May 18th - 10:25pm  "Episode 3"  Set Reminder
Medium  showing on TV4  May 19th - 7:30pm  "Episode 3"  Set Reminder
Medium  showing on TV4  May 20th - 1:25am  "Episode 3"  Set Reminder
Medium  showing on TV4  May 20th - 6:25pm  "Episode 4"  Set Reminder

but this shows rather:

    Medium  showing on TV4  May 18th - 6:25pm  "Episode 2"  Set Reminder
Medium  showing on TV4  May 18th - 10:25pm  "Episode 3"  Set Reminder
Medium  showing on TV4  May 19th - 7:30pm  "Episode 3"  Set Reminder
Medium  showing on TV4  May 20th - 1:25am  "Episode 3"  Set Reminder
Medium  showing on TV4  May 20th - 6:25pm  "Episode 4"  Set Reminder

I almost possess the SQL working simply not sure exactly what the right code is here now, to prevent the 2nd mistake showing - because the record (which signifies a show presently airing) doesn't appear to work on present.

Please can anybody assist me to with this particular?

Thanks

I'm not sure, however i would guess there is something strange about the way in which you're storing your time and date within the airdate column. Try managing a query such as this so that you can perform the same comparison you are asking the database to complete:

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