University of Vermont

College of Education and Social Sciences

Graduate Counseling Program

Doctoral Faculty

Alphabetical Listing of CESS Counseling Faculty and Staff "; //create alphabet array $alphabet = "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z"; $letters = explode(",",$alphabet); echo "


\n"; echo ""; // create categories foreach($letters as $list){ $getlastnames = "SELECT username, last_name FROM fads_users WHERE (username = 'jokech' or username = 'akindsva' or username = 'lcsmith' or username = 'ageroski' ) AND last_name LIKE '$list%' AND profile_status = 'on' group by username HAVING count(distinct username > 1) ORDER BY last_name ASC;"; $result = mysql_query($getlastnames); $num = mysql_num_rows($result); if ($num == 0) { echo "\n"; } else { echo "\n"; while ($row = mysql_fetch_assoc($result)) { $last_name = $row ["last_name"]; $username = $row ["username"]; $getusernames = mysql_query("SELECT username FROM fads_users WHERE username='$username' AND profile_status = 'on' group by username HAVING count(distinct username > 1)"); while ($row = mysql_fetch_assoc($getusernames)) { foreach ($row as $username) { $createnames = mysql_query("SELECT CONCAT(first_name, ' ',last_name) AS fullfaculty, primary_program, secondary_program, office, rank, phone FROM fads_users WHERE username = '$username' group by username ORDER BY last_name ASC"); while ($row = mysql_fetch_assoc($createnames)) { $fullfaculty = $row['fullfaculty']; $degree_type = $row['degree_type']; $primary_program = $row['primary_program']; $secondary_program = $row['secondary_program']; $office = $row['office']; $rank = $row['rank']; $phone = $row['phone']; } // end of while loop with $createnames $getdegree = "SELECT degree_year, degree_type, degree_field, degree_institution FROM fads_education WHERE `username` = '$username' AND `highest_degree` = 'yes' AND `display` = 'yes' ORDER BY degree_year DESC LIMIT 1"; $result = mysql_query ($getdegree); while ($row = mysql_fetch_assoc ($result)) { $degree_year = $row ["degree_year"]; $degree_type = $row ["degree_type"]; $degree_field = $row ["degree_field"]; $degree_institution = $row ["degree_institution"]; } if ($primary_program == "Not Applicable") { $primary_program2 = ""; } elseif ($primary_program == "Departmental Level Duties") { $primary_program2 = "$secondary_program

"; } else { $primary_program2 = "$primary_program

"; } //add in requested info from Jane Okech if ($username == "jokech") { $responsibility = "

Program Coordinator"; } elseif ($username == "lcsmith") { $responsibility = "

School Coordinator"; } elseif ($username == "akindsva") { $responsibility = "

Clinical Mental Health Coordinator"; } elseif ($username == "ageroski") { $responsibility = ""; } else $responsibility = ""; // echo" "; } // end of foreach $row as $username } //end of while with $getusernames } //end of else echo "\n"; } //end of with $list } echo "\n

CESS Counseling Faculty - Alphabetical Listing

Name

Affiliation

Contact

$fullfaculty, $degree_type

$rank $responsibility

>email

"; ?>


CESS Counseling Adjunct Faculty - Alphabetical Listing

Name

Contact

John (Jay) R. Gleason, MS, LCMHC, LADC, NCC

>email

Eric Nichols, Ph.D.

>email

Anthony Quintiliani, Ph.D.

>email

Richard Reid, Ph.D.

>email

Kevin Rodgers, MD

>email

Sarah Sears, MS, LCMHC

>email

Justin Tauscher, MS, LCMHC, LADC

>email

Nancy Weber, MS, LCMHC

>email

Contact UVM © 2014 The University of Vermont - Burlington, VT 05405 - (802) 656-3131