In Progress

PHP/mysql query from two tables

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.

jobs table

JobID

city

state

position

closingdate

EmailNotification table

EmailID

category1

category2

category3

emailaddress

memberid

Skills: MySQL, PHP

See more: state of n.c. jobs, state jobs, php mysql job, n query, job matches, city jobs, two hours, send query, query table, mysql query, send email php mysql, query email, php server cron job, php mysql email server, cron jobs php, cron mysql, notification server php, query query, send email hours php, mysql php state city, cron php, mysql query php, cron job email notification, php mysql server, php mysql bid

About the Employer:
( 43 reviews ) Port Charlotte, United States

Project ID: #1244690

Awarded to:

brendonf

Hi - I will start this immediately and will definitely have it done within 2 hours (probably less than an hour). Please see PM.

$30 USD in 0 days
(35 Reviews)
5.1

5 freelancers are bidding on average $37 for this job

acesolution

lets do it now.....thanks

$35 USD in 0 days
(103 Reviews)
6.5
roonex

Can do this in 2-3 hours

$60 USD in 0 days
(103 Reviews)
5.8
atifmajeed12

Ready to do it

$30 USD in 0 days
(28 Reviews)
5.1
achillesJK

Hello, sir. I can help you.

$30 USD in 0 days
(3 Reviews)
2.4