Jump to content


Photo

[SOLVED] Problem with distinct...


  • Please log in to reply
No replies to this topic

#1 kobbe

kobbe
  • Members
  • Pip
  • Newbie
  • 1 posts

Posted 10 October 2003 - 02:41 PM

I have a table with: id, email, typeofmember, somethingelse

I need to select DISTINCT email and so only email field got selected by DISTINCT.

When I do:
SELECT DISTINCT email, typeofmember, somethingelse FROM table;
I still don\'t get \"unuiqe\" email...

After reading alot of posts here I\'ve tested this:
$temp = mysql_query ("CREATE TEMPORARY TABLE temp_email_db AS SELECT DISTINCT email FROM fint_mail_db WHERE mailtyp=$mailtyp");$result = mysql_query ("SELECT a.email AS email, a.mailtyp AS mailtyp, a.id_code AS id_code, a.id AS id FROM fint_mail_db AS a, temp_email_db AS b WHERE a.email=b.email");$temp = mysql_query ("DROP TABLE temp_email_db");

But that does not work either cause I need it by id... and if I do it by id email doesn\'t get distinct :)

I need help ;)

Thx in advance, sry for my bad explaining...


Edit:
WIIIIIIIIII =) I did it =) *happy again*

SELECT email, mailtyp, id_code, id FROM fint_mail_db GROUP BY email ORDER BY email






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users