[code] $nowtime = date("Hi"); //Getting time $nowday = date("D"); //Getting day $query = mysql_query("SELECT * FROM show WHERE day like '$nowday'") or die(mysql_error());//Getting all data from the table where the show is to day $query_rows = mysql_num_rows($query); //Seeing if there is any if($query_rows > 0)//if more than 0 then there is atleast 1 show today { while($shows = mysql_fetch_array($query)) // putting into an array { $start = $shows['start']; $end = $shows['end']; } if(($nowtime =< $end) && ($nowtime >= $start)) //checking if the time is inbetween show times { echo "<font color=#FF0000>Show</font>"; } else echo "<font color=#000000>Show</font>"; }echo "<font color=#000000>Show</font>"; [/code] Something I threw together, I hope thats what you want.