RE: [PHP-DB] Select
| From: | Bastien Koert | Date: | Tue, 17 May 2005 13:08:10 +0000 |
| Subject: | RE: [PHP-DB] Select | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39482@lists.php.net to get a copy of this message | ||
distinc needs a field
select distinct(name) from table
bastien
From: MIGUEL ANTONIO GUIRAO AGUILAR <miguel.guirao@mail.telcel.com> To: php-db@lists.php.net Subject: [PHP-DB] Select Date: Mon, 16 May 2005 19:26:20 -0700 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? -------------------------- MIGUEL GUIRAO AGUILERA Logistica R8 - Telcel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php