select distinct * from mytable is functioning just as it should what the
answer is not group by try pleas to explain better what do you want
almir
"Jared Howard" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
