1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Alphabetical Ordering from a database

Discussion in 'PHP' started by travist6983, Feb 17, 2010.

  1. travist6983

    travist6983 New Member

    Joined:
    Feb 17, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    I am trying to figure out how to alphabetize a client list that draws from my data base here is the code i am playing with if any one could help nudge me ;) in the right direction i would be forever grateful

    PHP:
     $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) > )
                                    {
                                        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
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    I am still trying to understand what you are trying to do? I guess you need to know that SQL as a language is case insensitive and so order by clause will always work.
     
  3. travist6983

    travist6983 New Member

    Joined:
    Feb 17, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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
     

Share This Page