SELECT * FROM thetable GROUP BY column1;
That should work read > http://www.mysql.com/manual
SELECT *, GROUP_CONCAT(column2) as column2 FROM thetable GROUP BY column1;
But this requires mysql 4.1. If you don't have mysql 4.1, detect in your while loop if column1 is not equal to the previous one, then start a new row.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
