include_once("../inc/inc_header.php"); // Standard Header
include_once("../template.php"); // Page template
ob_start("template"); // Start Output Buffer
$sql = '
select * from sponsors
where approval = 1
order by company
';
$result = db_exec_sql($sql,"webdb");
$resultcount = count(mysql_num_rows($result));
if ($resultcount > 0){
for ($i = 0; $row = mysql_fetch_row($result); $i++){
$sponsorlist[$i]['name'] = $row[1];
$sponsorlist[$i]['company'] = $row[2];
$sponsorlist[$i]['type'] = $row[12];
}
}
?>
Leadership Teacher - Leadership Teacher Program Sponsors
Leadership Teacher would like to thank the following sponsors for their generous
program support:
VISIONARIES
foreach($sponsorlist as $details){
if ($details['type'] == "Visionaries"){
if ($details['company']){
echo "- " . $details['company'] . "
";
} else {
echo "- " . $details['name'] . "
";
}
}
}
?>
STRATEGIC PARTNERS
foreach($sponsorlist as $details){
if ($details['type'] == "Strategic Partners"){
if ($details['company']){
echo "- " . $details['company'] . "
";
} else {
echo "- " . $details['name'] . "
";
}
}
}
?>
SUSTAINING PARTNERS
foreach($sponsorlist as $details){
if ($details['type'] == "Sustaining Partners"){
if ($details['company']){
echo "- " . $details['company'] . "
";
} else {
echo "- " . $details['name'] . "
";
}
}
}
?>
PARTNERS
foreach($sponsorlist as $details){
if ($details['type'] == "Partners"){
if ($details['company']){
echo "- " . $details['company'] . "
";
} else {
echo "- " . $details['name'] . "
";
}
}
}
?>
PROFESSIONAL SOCIETIES
foreach($sponsorlist as $details){
if ($details['type'] == "Professional Societies"){
if ($details['company']){
echo "- " . $details['company'] . "
";
} else {
echo "- " . $details['name'] . "
";
}
}
}
?>
GENERAL SPONSORS
foreach($sponsorlist as $details){
if ($details['type'] == "General Sponsors"){
if ($details['company']){
echo "- " . $details['company'] . "
";
} else {
echo "- " . $details['name'] . "
";
}
}
}
?>
IN-KIND SERVICES
foreach($sponsorlist as $details){
if ($details['type'] == "In-Kind Services"){
if ($details['company']){
echo "- " . $details['company'] . "
";
} else {
echo "- " . $details['name'] . "
";
}
}
}
?>
IN-KIND SPONSORS
foreach($sponsorlist as $details){
if ($details['type'] == "In-Kind Sponsors"){
if ($details['company']){
echo "- " . $details['company'] . "
";
} else {
echo "- " . $details['name'] . "
";
}
}
}
?>