I thought I had it by adding if ($Month == date("n") and $DayOfWeek == date("j")) but it's not displaying any results. Did I do something wrong? (Yes, I did do something wrong: I used $DayOfWeek instead of $Day -- never mind! blush )

PHP Code

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

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

$today = date("nj");  // month n (1-12) day j (1-31)
echo $today;		  // just making sure data is as entered

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'];

	if ($Month == date("n") and $DayOfWeek == date("j")){
	
	$display_block .= "
		<TR> 
			<TD><FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'>$AirTime</FONT><BR></TD>
			<TD><FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'><B>$Movie</B></FONT><BR></TD>
			<TD><FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'>$Channel</FONT><BR></TD>
		</TR>
	";
	}
}

?>


<p align="center"><b><font size="3" face="Verdana, Arial, Helvetica, sans-serif">Today on TV</font></b></p>

<table cellspacing="0" cellpadding="4" align="center" border="1">

	<tr> 
	  <th><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Time (ET)</font></th>
	  <th><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Movie</font></th>
	  <th><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Chan</font></th>
	</tr>

	<!-- BEGIN : EMBED DATA FROM MYSQL DATABASE -->

	<? echo "$display_block"; ?>

	<!-- END : EMBED DATA FROM MYSQL DATABASE -->
		
</table>
Thanks wink

Last edited by jgeoff; 02/17/2008 4:39 PM.
GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 8.1.34 / MySQL 5.7.23-23 / Apache 2.4.67
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP