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;


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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to