RE: [PHP] MySQL "DISTINCT" query

I'm not sure what you're trying to do, but have you tried SELECT DISTINCT * FROM tablename; ? jack -----Original Message----- From: Jared Howard [mailto:webbie@deanox.com] Sent: Wednesday, March 21, 2001 1:05 PM To: php-general@lists.php.net Subject: [PHP] MySQL "DISTINCT" query I need to retrive all column information from a DISTINCT query. But so far, I only can get one column to show by using this: SELECT DISTINCT my_column FROM my_table; which then gives me a list of my_column information and is correct, but I need all information from all columns. Querying this: SELECT DISTINCT my_column, my_column2, my_column3, my_column4 FROM my_table; was my guess at it, but doesn't work how I'd like. -- 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