Using Recordset from a Different Table in Where Cause

I have a page that dynamically displays time based on actual time and date. It is only 1 PHP page but depends on 3 tables to work. Lines 42-65 are the problem. I want it to read the data from the tables instead of the way I have manually coded it.

The 3 tables are:

*bell_schedule-A table that has the start and stop time by period in a day. It lists every possible schedule.

*bell_schedule_weekly-A table that manages what day of the week (Mon=1, Tue=2, etc) the bell_schedule should follow.

*bell_schedule_dates-Exceptions to the bell_schedule_weekly. On the exception date a new schedule needs to be followed. I use the day number the date follows to determine if it should follow the exception's schedule.

The task I am hiring you for is to clean up my if, elseif statement so that it is based off the data in the table and not the manual way I coded (lines 42-65). I also want you to build an interface to insert data into the tables. It would have to have pull-down for inputting the time (bell_schedule) and a datepicker to select the date (bell_schedule_dates and a simple input interface to pick the base pattern of Monday through Friday and which schedule to follow (bell_schedule_weekly).

I am willing to pay you $20 for elseif fix and $25 for interface. I also have some other small page issues that are dependent on bell_schedule which I can pay extra. I could use help.

Let me know if I have not made myself clear.

Taidot: MySQL, PHP

Näytä lisää: statement problem, base exception, problem statement, different project using matlab

About the Employer:
( 9 reviews ) Plainfield, United States

Projektin tunnus: #8667972

Myönnetty käyttäjälle:


Hi, Thanks for your information. I can able to help you with solve your else if condition issue. ping me on chat so we can chat further and start work asap. Thanks Amit

20 $ USD 1 päivässä
(21 arvostelua)

5 freelanceria on tarjonnut keskimäärin 35 $ tähän työhön


I'm a Web Developer having a lot of experience in PHP, MySql, HTML etc. I can do this job for you. Please consider my bid. Thanks

50 $ USD 1 päivässä
(19 arvostelua)

Hello, 3 days to complete both sides of project. Quicker if i have more time available. Thanks Alex

55 $ USD 3 päivässä
(11 arvostelua)

I can do this for you, I have PHP, MYSQL, Drupal, HTML5, CSS3. I have done lot of projects in PHP which i can share you the link if you are interested.

25 $ USD 1 päivässä
(1 arvostelu)

A proposal has not yet been provided

25 $ USD 1 päivässä
(0 arvostelua)