MySQL Forums
Forum List  »  PHP

Apply Filter using Textbox entry
Posted by: Harry Lodge
Date: July 23, 2011 02:48PM

Hi guys

I have built a very basic database with php form on my website,

I have the following Tables, JOBS, EMPLOYEES & CUSTOMERS

Employees holds all employee info, same with customers etc. JOBS allows the employee to enter a "timesheet" setup for each job that day,

At the bottom of the form, I would like to use a sort of "subform" like ms access would use..

Job Main Details
****************
At end of page - TABLE VIEW of dates & times for that job


So Ideally, I need to apply a filter based on EMPLOYEENAME, At the top of JOBS, the employee selects his name and fills out the data, so if I could use that same combobox to select the employee, not only will it add data to MYSQL but also SHOW a TABLE VIEW for that employName further down, OR on another page?

Any help

Options: ReplyQuote


Subject
Written By
Posted
Apply Filter using Textbox entry
July 23, 2011 02:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.