RE: [PHP-DB] Re: Select

Miguel Guirao wrote: > 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@ozemail.com.au] > Sent: Martes, 17 de Mayo de 2005 03:42 p.m. > To: php-db@lists.php.net > Subject: [PHP-DB] 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 > That should work as you expect it to. David