I'm wondering if this is set up in the best way. Basically I need contact_email, contact_name, contact_id, but no duplicates for contact_email ONLY. IE - I WANT the record if it has the same NAME as another, but has a different email...and so on...
Code:
msql = "SELECT distinct contact_email, min(contact_name) as contact_name, min(contact_id) as contact_id FROM db_contact WHERE contact_comment=TRUE and contact_form_page = '/folder/pagename.asp' group by contact_email"