HITA Trained Teacher’s List

HITA Trained Teacher’s List.
(additional verbibage here)

//DO NOT ALTER CODE BELOW! – Check with Munjal
global $wpdb;

if ($wpdb) {
$statelistdb = $wpdb->get_results( “SELECT distinct(state) FROM hi_hita_teacher_list where country = ‘USA’ order by state” );

foreach ( $statelistdb as $state) {

$stabbrv = trim($state->state);
echo ““.$stabbrv.” | “;
}
} else { echo “There has been a database error. Please try again later.”; }

if ($wpdb)
{
$count = 0;
$teacherlistdb = $wpdb->get_results( “SELECT * FROM hi_hita_teacher_list where country = ‘USA’ order by state” );
$state = “”;
$prev_state = “”;

echo “

“;
foreach ( $teacherlistdb as $teacher ) {

$state = $teacher->state;
if ($state != $prev_state) {

echo “

“;

} else {
if(($count % 4) == 0) {
echo “

“;

} else {
echo “

“;
}
}

$prev_state = $teacher->state;
$count++;

}
echo “


“.$state.”
“.$teacher->firstname.” “.$teacher->lastname.” “.trim($teacher->city).”, “.trim($teacher->state).” “.$teacher->phone.” “.$teacher->email.”
“.$teacher->firstname.” “.$teacher->lastname.” “.trim($teacher->city).”, “.trim($teacher->state).” “.$teacher->phone.” “.$teacher->email.”	“.$teacher->firstname.” “.$teacher->lastname.” “.trim($teacher->city).”, “.trim($teacher->state).” “.$teacher->phone.” “.$teacher->email.”