NEED THIS TODAY... pls do not bid if you can not complete this today. (meaning in the next few hours)
Need a php/mysql query to send emails to members about jobs.
I have a jobs table and a emailnotification table.
I want to send daily emails to members when a the jobs table “position” matches one of the 3 job category they choose and listed in the email notification table and send emails out daily.
All members have a memberid and I have another script they enter their info for their email address and a dropdown window that list job categories they can choose. The can choose up to three categories and all this info is stored in the EmailNotification table.
I will use cron to send out daily emails by running the script