Code: Select all
$query = "SELECT id, firstName, email, lastName, LEFT(lastName, 1) AS first_char FROM userAccounts WHERE UPPER(LEFT(lastName, 1)) BETWEEN 'A' AND 'Z' OR LEFT(lastName, 1) BETWEEN '0' AND '9' ORDER BY lastName WHERE assignedAgent = ".$_SESSION['agent']['agentID'];
$clients = mysql_query($query);
$current_char = '';
if( mysql_num_rows($clients) > 0 )
{
while( $client = mysql_fetch_array($clients) )
{
if ($client['first_char'] != $current_char) {
$current_char = $client['first_char'];
echo '<br />' . strtoupper($current_char) . '<br />-----<br />';
}
echo "<tr>";
echo " <td>".$current_char['lastName']."</td>";
echo " <td>".$client['firstName']."</td>";
echo " <td>".$client['email']."</td>";
echo " <td>".$client['group']."</td>";
echo " <td align='center'><a href=\"editClient.php?clientID=".$client['id']."\">Edit Client</a></td>";
//echo " <td><a href='clientWebforms.php?clientID=".$client['id']."'>View Webforms</a></td>";
echo "</tr>";
}
}
else
echo "<tr><td colspan='3' align='center'><font color='red'>You have no clients assigned! To have your clients assigned to you search for them using the 'Find Clients' button on the left navigation bar.</font></td>";
Thanks for any and all comments
Travis