At 2:28 +1300 1/20/02, Barry Rumsey wrote: >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?
That's how you do it (add DISTINCT after the SELECT keyword). You must be doing something else wrong. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]