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
jobs table
JobID
city
state
position
closingdate
EmailNotification table
EmailID
category1
category2
category3
emailaddress
memberid
Hello,
I have over 8 years experience as a Linux admin and PHP developer. I can create the script for sending emails and also setup the cron. Thnak You