Re: ordered alpabeticaly list

If I understand you correctly, you want to put a separator when the letter changes. Try this: $result = mysql_query('select name from people order by name'); $lastletter = ''; while ($data = mysql_fetch_array($result)) {

    $curletter = strtolower(substr($data['name'],0,1));
    if ($curletter != $lastletter) {
        // Put code to insert a separator here
    }
    // put code to display the name here
    $lastletter = $curletter;

} Mike Rodrigo Peres wrote:

Hi list, I have a mysql tables, with names on it. I'd like to select this names ordered by name and output it to a html in alphabetical order, but separates by letter, ex: a, names with a, b.... I've done the select, but I can't figure out how to output the respective letters separated. Thank's in advance Rodrigo Peres