...

View Full Version : Show Duplicate rows



Atrhick
12-20-2011, 03:59 PM
Awesome thank you so much!!! I also have another question for you. here is my code

Here is my code, it looks fine me "I am not great at MYSQL yet"



$query_str99 = "SELECT lead_type, afid_seller_name, partner_id_buyer, price_buyer_paid, price_CIQFY_paid, time, email "
. " FROM lead_partners_pages "
. " INNER JOIN (SELECT email FROM lead_partners_pages GROUP BY email HAVING count(id) > 1) dup ON email = dup.email "
. " WHERE date_month = MONTH(NOW()) "
. " ORDER BY id DESC ";


But I am getting this message


Column 'email' in field list is ambiguous

guelphdad
12-20-2011, 04:21 PM
The "ambiguous" error means that more than one table has the same named column, but you have not specified which table so the database can't perform the call.

specify lead_partners_pages.email in the select statement instead of just email.

Atrhick
12-20-2011, 05:55 PM
The "ambiguous" error means that more than one table has the same named column, but you have not specified which table so the database can't perform the call.

specify lead_partners_pages.email in the select statement instead of just email.


Thank you!



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum