Insert into DB.
Search based on name.

Name:
Address Line 1:
Address Line 2:
Email:

Name:

\n"); mysql_select_db ($db); $name = mysql_real_escape_string ($_POST["name"]); $addr1 = mysql_real_escape_string ($_POST["address1"]); $addr2 = mysql_real_escape_string ($_POST["address2"]); $email = mysql_real_escape_string ($_POST["email"]); $query = "insert into address values ('$name', '$addr1', '$addr2', '$email')"; $result = mysql_query ($query) or die ("Query failed.
\n"); echo "Inserted successfully. Click here to continue."; } else if ($_POST["choice"] == "searchsubmit") { $connection = mysql_connect ($host, $user, $pass) or die ("Unable to connect to database.
\n"); mysql_select_db ($db); $name = $_POST["name"]; $query = "select * from address where name='$name'"; $result = mysql_query ($query) or die ("Query failed.
\n"); if (mysql_num_rows ($result) == 0) echo "No results found.
\n"; else { $row = mysql_fetch_assoc ($result); echo "Name: " . $row['name'] . "
\n"; echo "Address Line 1: " . $row['addr1'] . "
\n"; echo "Address Line 2: " . $row['addr2'] . "
\n"; echo "Email: " . $row['email'] . "
\n"; } echo "Click here to continue."; } ?>