I have two tables: for example
Customer Information
-------------------------
Name
Favorite Color ID

Color
--------
Favorite Color ID
Color


How can I display all customer names grouped by favorite color in this manner


Blue

Tom
Frank
Jim

Green

Sally
Mike
John

thanks for your help

This is mainly a sql question. Something like this might be what you're looking for:

<pre id=code><font face=courier size=2 id=code>
SELECT name,color
FROM customer INNER JOIN
color ON customer.colorID = color.colorID
ORDER BY color
</font id=code></pre id=code>