'; print_r($_POST); echo ''; } else { echo 'no post'; } $dbc = mysql_connect("localhost","root","james") or die(mysql_error()); mysql_select_db("tea_accounts",$dbc) or die(mysql_error()); //add a client $firstname = $_POST['Firstname']; $initial = $_POST['Initial']; $lastname = $_POST['Lastname']; $address1 = $_POST['Address_Line_1']; $address2 = $_POST['Address_Line_2']; $city = $_POST['City']; $state = $_POST['State']; $zip = $_POST['Zipcode']; $email_address = $_POST['Email_Address']; $result = mysql_query("INSERT INTO client_info (firstname,middle_initial,lastname,address1,address2,city,state,zip,email_address) VALUES ('$firstname','$initial','$lastname','$address1','$address2','$city','$state','$zip','$email_address')") or die(mysql_error()); if (!$result){ echo'could not enter in the database'; }else{ echo'your entry was successful'; } //Generate Form $result = mysql_query("SELECT * FROM client_info WHERE id = '1'"); $row = mysql_fetch_array($result) or die(mysql_error()); echo '
';
	print_r($row);
	echo '
'; echo '
'; $data = array( 'Firstname' => 'firstname', 'Initial' => 'middle_initial', 'Lastname' => 'lastname', 'Address Line 1' => 'address1', 'Address Line 2' => 'address2', 'City' => 'city', 'State' => 'state', 'Zipcode' => 'zipcode', 'Email Address' => 'email_address' ); foreach ($data as $name => $column) { echo '
 '; } echo '
'; ?>