OPAWA WARD";
echo "SACRAMENT TALKS
";
//$sql1="SELECT DATE_FORMAT(talks.date,'%M %d, %Y')as date, talks.person, talks.topic, CONCAT(speakers.name2,', ',speakers.name1) as name, speakers.id FROM talks, speakers WHERE talks.person = speakers.id ORDER BY name ASC";
if(!isset($_REQUEST['order']) || $_REQUEST['order']!='date'){
$sql1="SELECT CONCAT(name2,', ',name1) as name, id FROM speakers ORDER BY name ASC";
$result1=$dbConn->query($sql1);
echo "
| Name |
Topic |
Date [sort] |
\n";
$i=1;
while($row1=$result1->fetch()){
if($i%2==0){
$rowstyle="tabroweven";
}
else {
$rowstyle="tabrowodd";
}
$currname=$row1['name'];
$currid=$row1['id'];
echo "| $currname | ";
$sql2="SELECT DATE_FORMAT(date,'%d/%m/%Y') as talkdate, topic FROM talks WHERE person='$currid' ORDER BY date DESC";
$result2=$dbConn->query($sql2);
$numtalks=$result2->size();
$skip=1;
if ($numtalks>1){
while($row2=$result2->fetch()){
echo "".$row2['topic']." | ".$row2['talkdate']." |
\n";
$skip++;
if ($skip<=$numtalks){
echo "| | ";
}
}
}
else {
$row2=$result2->fetch();
echo "".$row2['topic']." | ".$row2['talkdate']." |
\n";
}
$i++;
echo "| |
\n";
}
echo "
\n";
} // end if not date sort
else {
$sql1="SELECT DISTINCT DATE_FORMAT(date,'%d/%m/%Y') as talkdate,date FROM talks ORDER BY date DESC";
$result1=$dbConn->query($sql1);
echo "
| Date |
Name [sort] |
Topic |
\n";
$i=1;
while($row1=$result1->fetch()){
if($i%2==0){
$rowstyle="tabroweven";
}
else {
$rowstyle="tabrowodd";
}
$date=$row1['date'];
$talkdate=$row1['talkdate'];
echo "| $talkdate | ";
$sql2="SELECT CONCAT(speakers.name2,', ',speakers.name1) as name, speakers.id, talks.person ,talks.topic FROM talks, speakers WHERE talks.person = speakers.id AND date='$date' ORDER BY name ASC";
$result2=$dbConn->query($sql2);
$numtalks=$result2->size();
$skip=1;
if ($numtalks>1){
while($row2=$result2->fetch()){
echo "".$row2['name']." | ".$row2['topic']." |
\n";
$skip++;
if ($skip<=$numtalks){
echo "
| | ";
}
}
}
else {
$row2=$result2->fetch();
echo "".$row2['name']." | ".$row2['topic']." |
\n";
}
$i++;
echo "| |
\n";
}
} // end if date sort
$content=ob_get_contents();
ob_end_clean();
require($_SERVER['DOCUMENT_ROOT']."/lds/incl/display.php");
$dbConn->close();
?>