= '" .$cut_off ."' OR prog_end >='" .$cut_off ."' ORDER BY prog_date, prog_time;";
$col1='rgb(223,255,191,0.2)';
$col2='rgb(225,192,192,0.2)';
$colh='rgb(16, 114, 42)';
?>
Programme
num_rows <> 0)
{
?>
| Date and time |
Event |
Where |
Description |
$curr_month)
{
if ( $m_cnt<>0)
{
echo "";
echo " |
";
}
$m_cnt=1;
$curr_month=$w_month;
$dateObj = DateTime::createFromFormat('!m', $curr_month);
$monthName = $dateObj->format('F') .' ' .substr($row['prog_date'],0,4);
echo "";
echo "| " .$monthName ." | ";
echo "
";
}
$w_date=$row['prog_date'];
$d=strtotime($w_date);
$edate = date('D jS', $d);
$w_date1=$row['prog_end'];
if ( $w_date <> $w_date1)
{
$d=strtotime($w_date1);
$edate = $edate .' - ' .date('D jS', $d);
if (substr($w_date,5,2) <> substr($w_date1,5,2))
{
$dateObj = DateTime::createFromFormat('!m', substr($w_date1,5,2));
$edate = $edate .' ' .$dateObj->format('F') ;
}
}
else
{
$w_time= $row['prog_time'] ;
// this convoluted code is because I could not get the correct time to show usng php features.
//it was always 3 hours in advance!
if(!is_null($w_time) and $w_time <> '00-00-00')
{
$w_hrs=substr($w_time,0,2)*1;
if ($w_hrs<12)
{ $ap ='AM'; }
else
{
$ap='PM';
$w_hrs=$w_hrs -12;
}
$w_mins=substr($w_time,3,2)*1;
$edate = $edate .' ' .$w_hrs;
if($w_mins<> 0)
{ $edate = $edate .':' .$w_mins;}
$edate = $edate .$ap;
}
}
$conf="To be confirmed";
if($row['prog_confirmed']<> 0)
{ $conf='';}
$link='';
if(strlen($row['prog_url'])> 0)
{ $link= " target = '_blank' href='" .$row['prog_url'] ."'";}
echo "";
echo "| " .$edate ." | ";
if($row['prog_url_position'] ==1)
{
echo "" .$row['prog_event'] ." | ";
}
else
{
echo "" .$row['prog_event'] ." | ";
}
if($row['prog_url_position'] ==2)
{
echo "" .$row['prog_location'] ." | ";
}
else
{
echo "" .$row['prog_location'] ." | ";
}
echo "" .$row['prog_details'] .$conf ." | ";
echo "
";
}
}
else
{
echo "No Events!!";
exit;
}
?>
