RE: [PHP] Re: ordered alpabeticaly list

Okay, haven't tested this but it should work. I would let mysql do some of the work here. In your select add something like Something like $result = mysql_query('select ucase(left(name,1)) as foo, name from userlist order by name'); $lastletter = ''; while ($data = mysql_fetch_array($result)) { $curletter = ($data['foo']); if ($curletter != $lastletter) { echo("<br>" . $curletter . "<br>"); } echo($data['name'] . "<br>"); $lastletter = $curletter; } As I say, I haven't tested this but it should work. Unless I stink... which I often do. -----Original Message----- From: Rodrigo Peres [mailto:rperes@mac.com] Sent: Thursday, December 13, 2001 1:36 PM To: php-general@lists.php.net Subject: Re: [PHP] Re: ordered alpabeticaly list Thnk's Mike, But what I really need is create a separation like this ex: A ab... ac.. ad.. B be... bee... .. for all the names in my table Thank's again Rodrigo on 12/13/01 4:30 PM, Mike Eheler at meheler@idearesource.com wrote: > 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 >> >> > -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net