Analyze and Update MySQL table from PHP

Completed Posted Feb 15, 2012 Paid on delivery
Completed Paid on delivery

Need a php function written that compares two tables and then updates table one based upon information in table two.

Table one contains a schedule for on-air video playback with about 10 columns but there are only 4 columns we need to worry about and update (Video ID, Scheduled run time, run time window, and run status). The second table contains an asrun of the day with a column containing the video ID and a column containing the run time.

We need to loop through the schedule table and for every entry look in the as-run table to see if the ID scheduled in the schedule table ran in the as-run table within the window of the air-time that is specified in the schedule table. If so, update that line in the schedule table with a "1" for the run status column and if not update the line in the schedule table with a "2" for the run status.

I can send you the two MySQL tables so you can get a better idea of the dataset.

MySQL PHP

Project ID: #1448786

About the project

8 proposals Remote project Active Feb 15, 2012

Awarded to:

Karsticum

I'm ready to start. You'll have the script completed in a couple of hours. You can't get a better offer!

$30 USD in 0 days
(27 Reviews)
4.3

8 freelancers are bidding on average $50 for this job

mdjavedakhtar

please check pmb

$30 USD in 1 day
(40 Reviews)
6.6
Butterfly718

Hello,sir. I can help you. Let's start.

$100 USD in 2 days
(33 Reviews)
4.8
piaoxin

Hi, sogorman. I can do it. Please check PM. thanks and regards.

$30 USD in 0 days
(23 Reviews)
5.2
lukepl

I can do it today.

$30 USD in 1 day
(7 Reviews)
3.8
redscraper

Hi, I am interested in this job posting. Please check PMB. Thanks

$30 USD in 1 day
(6 Reviews)
3.3
amitjatav1987

I will do it but i need full detail its about scheduling of job which will be handle by server not database. php+server setting will do this job.

$100 USD in 5 days
(0 Reviews)
0.0
ajeeshameen

Hi, Please have a look into the PM. Thanks and regards, Ajeesh

$50 USD in 1 day
(0 Reviews)
0.0