You are right David, I have an auto_increment field!!
What about this:
$items2 = mysql_query("SELECT DISTINCT rev FROM rev ORDER BY rev", $link);
where rev is a revision field for parts in my wharehouse!!!
Does it will work in this case?
Thanks
-----Original Message-----
From: David Robley [mailto:robleyd@xxxxxxxxxxxxxx]
Sent: Martes, 17 de Mayo de 2005 03:42 p.m.
To: php-db@xxxxxxxxxxxxx
Subject: Re: Select
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
