distinc needs a field

select distinct(name) from table

bastien

From: MIGUEL ANTONIO GUIRAO AGUILAR <[EMAIL PROTECTED]>
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


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to