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