Resources
- Event
- Appointment
- Challenge
= (SELECT leftNum FROM tblGroup WHERE groupID = ".$row1['groupID'].") AND rightNum <= (SELECT rightNum FROM tblGroup WHERE groupID = ".$row1['groupID'].")"; $result2 = mysql_query($query2,$link) or die('Errant query: '.$query2); while($row2=mysql_fetch_array($result2)) { $query3 = "SELECT DISTINCT U.userID, U.email, CONCAT(U.firstName,' ',U.lastName) AS 'fullName' FROM tblUser U JOIN tblGroupUser GU ON GU.userID = U.userID WHERE GU.groupID = ".$row2['groupID']; if($role) { $query3 .= " AND GU.roleID IN (SELECT roleID FROM tblRole WHERE roleName IN (".stripslashes($role).")) ORDER BY U.firstName ASC"; } $result3 = mysql_query($query3,$link) or die('Errant query: '.$query3); while($row3=mysql_fetch_array($result3)) { $check = multi_in_array($row3['userID'], $users); if($check == false) { $row = array(); $row['userID'] = $row3['userID']; $row['fullName'] = $row3['fullName']; $row['email'] = $row3['email']; $users[] = $row; } } } } function cmp($a, $b) { return strcmp($a["fullName"], $b["fullName"]); } usort($users, "cmp"); // print_r($users); ?>