query("update researcher set approved = 1 where researcher_id in (".join(',', $_POST['approved']).")"); $appr_email = $db->getCol("select email from researcher where researcher_id in (".join(',', $_POST['approved']).")"); foreach($appr_email as $appr) { mail($appr, "Your DASR account is approved", "Your DASR account is approved. Please visit\n\nhttp://$_SERVER[SERVER_ADDR]/DASR_2011\n\nBest,\nDASR Team", "From: DASR "); } $db->commit(); } $rsc = $db->query("select researcher_id, firstname, lastname, email from researcher where approved = 0"); $title = "Login"; require_once 'header.inc.php'; ?>

Approve new users:

fetchRow()) { if(!$header) { print "\n"; $header = true; } print "\n"; } ?>
" . join("", array_keys($r)) . "
"; print "" . join("", $r) . "