Jump to content

Archived

This topic is now archived and is closed to further replies.

kobbe

[SOLVED] Problem with distinct...

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.