that I was missing something. I have a table called email_results that
keeps track of products that users click on from an email they received.
In this table I have a unique ID that matches them up to their email
address and company name that is stored in another table called
email_blast.
If a person clicks on the same product twice a new row is added to the
email_results table that includes identical data. When displaying the
data if the same person clicked on a product more than once I only want
to show it one time, if that same person clicked on 2 separate products
I want to show each product they clicked on.
I thought by grouping by email address that I fixed the problem but then
noticed it will only show them as clicking on one product even if they
clicked on 2 different products.
Does anyone have any ideas on how I can do this? I didn't create the
tables or write the original code and I'm thinking they should have made
it so it only writes to the database if they are clicking on a new
product but it wasn't done that way so this is what I have to work with.
Thanks,
Ben
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
