In Progress

PHP/mysql query to send daily emails to members

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

Skills: MySQL, PHP

See more: daily mysql query email, mysql send daily email, php mysql job, n query, matches list, list matches, job matches, city jobs, daily email mysql query, send query, query table, mysql query, mysql dropdown, send email php mysql, need send emails, mysql running, send info, query email, cron jobs php, php job list, mysql php email script, cron mysql, dropdown city list, state city dropdown php, send email hours php

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

Project ID: #1241578

9 freelancers are bidding on average $136 for this job

FandaR

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

$100 USD in 0 days
(265 Reviews)
6.6
keiespro

Hello,sir I can do it within the timeline. Thanks

$150 USD in 0 days
(123 Reviews)
6.3
RedhopIT

Hi,Please check PM

$60 USD in 0 days
(64 Reviews)
6.2
teta

Ready to start. Check PM for details.

$195 USD in 1 day
(41 Reviews)
5.7
brendonf

Hi, I have worked on many similar projects. I will start immediately and work on it full time until it is complete.

$60 USD in 0 days
(38 Reviews)
5.4
mmffrooq

Lets get it done :)

$180 USD in 0 days
(30 Reviews)
5.1
websoft2009

Dear sir, I am ready to do it now. Please see PM for more details. Thanks.

$200 USD in 0 days
(18 Reviews)
4.7
dkouk

Hi,Ready to Start Check PM.

$55 USD in 0 days
(12 Reviews)
3.9
bentaylor

Can get this done for you ASAP. Can be contact a variety of ways. Can start immediately. Thanks Ben.

$150 USD in 1 day
(5 Reviews)
3.4
vishnu1989

hi, please see pmb for more detail. thanks, vishnu.

$250 USD in 2 days
(1 Review)
0.0
cybersky72528

Half and hour and i can cook up a totally flexible php code which will be able to send mails daily even at an allotted time :)

$30 USD in 0 days
(1 Review)
0.0