if(($_GET['submit']=='Show')){
$value= $_GET['date1'];
$qry1="select * from videos where date='$value'";
$data1=mysql_query($qry1);
$norows=mysql_num_rows($data1);
if($norows>0)
{
while($rec1=mysql_fetch_array($data1)) { ?>
}
}else{
header("location:index.php?mesg=noondate");
exit();
}
}else if($_GET['mesg']=='noondate') {
?>
No Video Found for Selected Date. Please Try Another Date.
}
else{
$today=date('Y-m-d');
$qry="select * from videos where date='$today'";
$data=mysql_query($qry);
$norows=mysql_num_rows($data);
if($norows>0)
{
while($rec=mysql_fetch_array($data)) { ?>
}
}else{
?>
No Video for Today's Schedule. Please Select a Video from Program Guide.
}
}
?>