Email already sent?

Question

Hi,

Can someone explain a simple solution using MySQL and PHP how to check if an email has been sent already, stopping duplicates for users.

I have a basic script, but it's not working for some reason - http://pastebin.com/k7yiQahb It inserts into the table the following:

feed_id, recipient_id, issent
0, 0, Y

Regards

Answer 1

Why not create a column issent of type enum(Yes,No) DEFAULT 'No' in the table recipients instead of a separate table.

Then, when email is sent successfully, run this:

 update `recipients` set issent = 'Yes' where id = $id

And when you are fetching email recipients in the beginning, just do:

 select email, suburb, id FROM recipients where issent = 'No' GROUP BY id ORDER BY id DESC

This will give you only unsent addresses.

[EDIT]: If there are multiple recipients, you can run first query like this:

 update `recipients` set issent = 'Yes' where id IN (3,4,5,6)