I'm not much of a programmer, but can usually figure simple things out w/ the code in front of me. Here I need some code added, so any help would be appreciated!

I have a TV Listings page on one of my sites. (I add/delete listings via phpMyAdmin). On another site, I would like to access that database but just display the results for today ("What's on Today")

Here is the original code:
PHP Code

<?php

$db_name = "XXXXXXX_gftv";
$table_name = "GFTV";

$connection = @mysql_connect("localhost", "XXXXXXX", "XXXXXXX")
or die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection)
or die("Couldn't select database.");


$sql = "SELECT ID, DayOfWeek, Month, Day, Year, Movie, Channel, AirTime
FROM $table_name
ORDER BY Year, Month, Day, AirTime
";

$result = @mysql_query($sql,$connection)
or die("Couldn't execute query.");

while ($row = mysql_fetch_array($result)) {
$ID = $row['ID'];
$DayOfWeek = $row['DayOfWeek'];
$Month = $row['Month'];
$Day = $row['Day'];
$Year = $row['Year'];
$Movie = $row['Movie'];
$Channel = $row['Channel'];
$AirTime = $row['AirTime'];

$display_block .= "
<TR>
<TD bgcolor=#eeeeee><FONT size=2 face='Verdana, Arial, Helvetica, sans-serif'>$DayOfWeek $Month/$Day</FONT><BR></TD>
<TD bgcolor=#ffffff><FONT size=2 face='Verdana, Arial, Helvetica, sans-serif'><B>$Movie</B></FONT><BR></TD>
<TD bgcolor=#ffffff><FONT size=2 face='Verdana, Arial, Helvetica, sans-serif'>$Channel</FONT><BR></TD>
<TD bgcolor=#ffffff><FONT size=2 face='Verdana, Arial, Helvetica, sans-serif'>$AirTime</FONT><BR></TD>
</TR>
";

}

?>

Now, two questions...

1) Is there an easy way to just display shows airing today? (on the second site)

2) How can I get it to sort by AirTime (tiny text) properly? Because it will display 10 PM before 1:30 PM, and 11:30 AM before 12 AM, etc. I really don't want to use 24-hour time if I can help it (or at least have it convert 24-hour time to 12-hour time?)

Thanks for any guidance!

JG

PS - If it matters, here's the structure:

Code
ID        int(10) auto_increment
DayOfWeek tinytext
Month     tinyint(2)
Day       tinyint(2)
Year      smallint(4)
Movie     tinytext
Channel   tinytext
AirTime   tinytext

GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP