\n"; echo "\n"; echo "RTC Washoe Meeting Agendas feed\n"; echo "RTC Washoe Meeting Agendas RSS Feed\n"; echo "http://www.rtcwashoe.com/news-events-41\n"; if ($committee != ''){ $SQL="SELECT date, agenda_pdf, location, committee, topic FROM agendas WHERE committee='".$committee."' AND agenda_pdf <> '' ORDER BY date DESC"; } else{ $SQL="SELECT date, minutes_pdf, agenda_pdf, location, committee, topic FROM agendas ORDER BY date DESC"; } $result=mysql_query($SQL) or die("\n"); while($agenda = mysql_fetch_assoc($result)){ if ($agenda['agenda_pdf'] != '') { echo "\n"; echo "".date("F j, Y", strtotime($agenda['date']))." ".strtoupper(htmlentities(strip_tags($agenda['committee'])))." agenda posted\n"; echo "http://www.rtcwashoe.com/news-events-41\n"; echo "\n"; echo "Visit http://www.rtcwashoe.com/news-events-41 for the full PDF document"; echo "\n"; echo "\n";} /* echo "".htmlentities(strip_tags($detour['title']))."\n"; echo ""; echo "[INBOUND DETOUR] ".htmlentities(strip_tags($detour['inbound'])); echo " [OUTBOUND DETOUR] ".htmlentities(strip_tags($detour['outbound'])); echo " [TIME] ".date("F j, Y", strtotime($detour['s_date'])); echo " - ".date("F j, Y", strtotime($detour['e_date']))." "; echo htmlentities(strip_tags($detour['time_details'])); echo "\n"; echo "\n";*/ } mysql_free_result($result); echo "\n"; echo ""; ?>