NEED THIS TODAY... pls do not bid if you can not complete this today. (meaning in the next 2 hours)
Need a php/mysql query from two tables
I have a jobs table and a emailnotification table.
I will use cron on server 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 .
The fields that relate are [url removed, login to view] and [url removed, login to view]
So I need a query that checks for matches between category 1, 2 and 3 with [url removed, login to view] for each member_id which will then send an email when it is call by the cron settings on the server.