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ää: what is the problem statement, what is problem statement, what is a problem statement, statement of a problem, pick-n pull, base exception, a problem statement, create table xml file using, can separate digits different arrays using pointer, create table csv files using, javascript change table cell background using input, creating directory different server using, create xml type table sql server using vbnet, copy paste table within word using, convert unicode different font using cnet, different projects using simple database, different project using matlab

Tietoa työnantajasta:
( 9 arvostelua ) 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 %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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)