distinct - how to do
| From: | Barry Rumsey | Date: | Sat, 19 Jan 2002 13:28:57 +0000 |
| Subject: | distinct - how to do | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15993@lists.php.net to get a copy of this message | ||
I have the following query:
$query = "SELECT * FROM xp_topics, xp_stories WHERE xp_topics.topicid = xp_stories.topicid AND
xp_topics.artistname='Faith Hill' ORDER BY topictext DESC LIMIT 0,20";
It returns the lot but a lot of doubles.
I want to put a DISTINCT call the query, but if I put it after the select ( select distinct *
from.......) it returns nothing. How do you do a DISTINCT?