get_results( “SELECT * FROM hive_production.person LEFT JOIN hive_production.program_person ON (person.id = program_person.person_id) WHERE program_id=’5′ AND type=’participant’ ORDER BY fname ASC”, ARRAY_A );

foreach ($participants as $participant) {

//this makes sure there are not html injection issues, and it fixes all of the special characters
$html = array_map(function ($e) { return htmlentities($e, ENT_NOQUOTES, ‘UTF-8’);}, $participant);

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“; echo ““; echo “

“; echo “ {$html[‘fname’]} {$html[‘lname’]} “; echo “ {$html[‘organization’]} “; echo “ {$html[’email’]} “; echo “ {$html[‘bio’]} “; echo “

“;
}

?>