Group by email+product,email,etc.
At 03:44 PM 11/25/2003, you wrote:
>I thought I had figured out a way to display some info but then realized
>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]
