Results 1 to 5 of 5

Thread: Use date picker to create $variable for query

Threaded View

  1. #1
    Join Date
    May 2012

    Exclamation Use date picker to create $variable for query

    Hi All,

    I'm hoping I can get some help with my code. I have been working on it for quite some time and I have gotten just about everything working.

    What the page currently does:
    #1 Queries my database to get a list of options for my drop-down menu
    #2 On selecting an option from the generated drop-down, the page reloads and queries my database, returning only users that meet the shifts from my drop-down.

    What I still what it to do:
    The very first thing I would like my form to do is to have a datepicker (already have one working on the page). When selecting a date, the date is pushed into the first query Point #1. This query will the select only options (shifts) that are available on that date.
    Once the shift is selected the query in Point #2 must only select users from the second table who are scheduled for that date, and the selected shift.

    Below is my complete code. The code below functions perfectly as describe in under the "What the page currently does" section.

    PHP Code:
    My page is attached
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center