Gaudaudinh
New Member
I have a (PHP) script which runs on a new row in MySQL. However, it will continually send the emails, even if they've already been sent...causing mass emails into the users Inbox. The script is quite big, so I cant paste it here - http://pastebin.com/6v75F4Gv Is there anyway I can somehow check if this script has already sent 'xx' email, but if a new row containing 'zz' and the user has specified they wish to receive content containing 'zz' it sends the 'zz' row?ie. It stops duplicate/etc. emails.Note: MySQL table is in the following format:
Table: \[code\]feed\[/code\]
Rows in pager: \[code\]id\[/code\], \[code\]title\[/code\], \[code\]description\[/code\], \[code\]date\[/code\]
Table: \[code\]recipients\[/code\]
Rows in recipients: \[code\]id\[/code\], \[code\]email\[/code\], \[code\]suburb\[/code\]Thanks
Table: \[code\]feed\[/code\]
Rows in pager: \[code\]id\[/code\], \[code\]title\[/code\], \[code\]description\[/code\], \[code\]date\[/code\]
Table: \[code\]recipients\[/code\]
Rows in recipients: \[code\]id\[/code\], \[code\]email\[/code\], \[code\]suburb\[/code\]Thanks