Re: Select
| From: | David Robley | Date: | Tue, 17 May 2005 20:42:02 +0000 |
| Subject: | Re: Select | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39481@lists.php.net to get a copy of this message | ||
Miguel Antonio Guirao Aguilar wrote:
> Hi!!
>
> I have this query in PHP:
>
> $items2 = mysql_query("SELECT DISTINCT * FROM rev ORDER BY rev", $link);
>
> I have three rows with the same data on it, and DISTINCT seems to be not
> working, since I got all the rows, any ideas of what is going wrong?
Without knowing how many fields you have and what they are, no. But you
should realise that DISTINCT looks at _all_ selected fields in a record, so
if you have an auto_increment id field in amongst those selected, all the
records will be different.
David