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:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 1:05 PM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
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]
