I am not really a php programmer but figured i would give this a try to eliminate some work from my co-workers.

basically what i was trying to do was the order the clients alphabetically by last name instead of by there database ID this was the old statement that i am trying to edit
$query = "SELECT lastName, id, firstName, email FROM userAccounts WHERE assignedAgent = ".$_SESSION['agent']['agentID'];

and you obviously can see the new statement that i created from reading a bunch of forum posts.

Any help would be greatly appreciated

thanks

Travis