Candidate: With Excellent English Written/Verbal Skills and Living in the USA
We have the need to add a simple customer support system to our current website.
We are pretty flexible on design, but would like the code written in PHP with the database in MySQL.
The objective of this project is create web pages to support a customer administration database that consists of 2
Industry Area table
Both tables require screens to support insert, update, delete, and selecting options.
Customer records should allow a search on a part of the Company name, and the ability to page up and down the
records with a function key. Once the record is found it should be able to be updated, or deleted. When viewing
the Customer table screens Industry area should show up as a drop down list based on the table entries in the
Industry Area table.
Table layouts are shown below.
1) Customer table page
a)Customer id Number (unique key, integer).
c)Contact person First Name
d)Contact person Last Name
k)Industry area - new MySQL table -- drop down on customer screen.
2)Industry Area table