mysql > database
DB1 - name, sex, dob, address
content of db
Record 1- Jerry, Male, 20-05-1983, Kuala Lumpur, Selangor, Malaysia
Record 2- Michelle, Female, 11-11-1992, Kowloon, Hongkong
Record 3- Jed Chan, Male, 23-03-1972, Singapore
Write a Form which content the following field
Sex: Dropdown List
Date of Birth: Textbox
Address: Textbox with multiple line
When user keyin the content for name, it will filter the database with suggestion box. Suggestion box showing the keyword in BOLD. Once user selected the text from suggestion box, the field "sex, date of birth and address" will be auto filled. Auto filled content can be edit, but this will not overwrite the content in Database.
1st e.g - If user key in "je" in the Name text box - the suggestion box will listed "Jerry" with the "je" letters in Bold, once selected the text, the field "sex, date of birth and address" will be auto filled.
2nd e.g If user key in "e" in the Name text box - the suggestion box will show "Jerry, Michelle and Jed Chan" with the letter "e" in BOLD.