list box selection to display record in form

peptct

I have developed a database in mysql and php for contact management. I have programed in several older languages but am new to both mysql and php. I need to display information in a form but want to select the record from a drop down list either by typing or selecting from scroll. Problem 1 first and last name in seperate fields so search in list box a problem because I can only select one field. Second... after selection of name in dropdown list how to tell the form to refresh to the record selected. Third I would like to display contact information in a form on the top of the page (from the selection from listbox) and at bottom a list of touchpoints that pertain to that contact from the touchpoints table. This was so easy in access and I am sure is possible in php but I cant seem to find any books or tutorials to explain how to. Any help would be much appreciated !!
Phil

mattis

I'm not sure I understand everything you mentioned, but hopefully I can help you with some of the problems.

If you have first and last name i seperate fields i DB you can display both in the selection field.
```
<select><option>lastname fistname</option></select>
```
When you select from the selection field you refresh page with a querystring using the database ID (page.php?id=13).

Then you can set the code to load some variables with the data fron DB.

if(isset($_GET["id"]))

You then display the variables in the form.

If you have a seperate DB table with touchpoints you can display a list of touchpoints related to the contact information with ID 13.

Did I understand any of your problems right?

// Mattias