[SOLVED] MySQL INSERT command adding a blank record

suttercain · April 4, 2007

Good morning,

I have a form that I am INSERTing into the MySQL database. I have the names and vaules set. The columns header is the same but when I "submit" the form it adds a blank record to the database. If I add another one, another blank record is added.

<?php
  $errors=array();
  if(isset($_REQUEST['submit'])){ // If the form was submitted
     validate_input(); // Check for empty fields
     if(count($errors) != 0){ // If there are errors,
      // redisplay the form
         display_form();
     }
     else{ preview_form(); }
   }
   else{display_form();} // Display the form for the first time
   
   if(isset($_REQUEST['final'])){
   		submit_final();
	}

if($_REQUEST['go_back']){
	validate_input();
	}

function validate_input(){
	global $errors;
	if ($_POST["first_name"] == "") {
	$errors['first_name']="<font color='red'>
	Please enter your First Name.</font>";
	}
	if ($_POST["last_name"] == "") {
	$errors['last_name']="<font color='red'>
	Please enter your Last Name.</font>";
	}
	if ($_POST["street"] == "") {
	$errors['street']="<font color='red'>
	Please enter your Street Address.</font>";
	}
	if ($_POST["city"] == "") {
	$errors['city']="<font color='red'>
	Please enter your City.</font>";
	}
	if ($_POST["state"] == "") {
	$errors['state']="<font color='red'>
	Please select your State.</font>";
	}
	if ($_POST["zip_code"] == "") {
	$errors['zip_code']="<font color='red'>
	Please enter your Zip Code.</font>";
	}
	if ($_POST["vehicle_year"] == "") {
	$errors['vehicle_year']="<font color='red'>
	Please enter the Year of the Vehicle.</font>";
	}
	if ($_POST["vehicle_make"] == "") {
	$errors['vehicle_make']="<font color='red'>
	Please enter the Make of the Vehicle.</font>";
	}
	if ($_POST["vehicle_model"] == "") {
	$errors['vehicle_model']="<font color='red'>
	Please enter the Model of the Vehicle.</font>";
	}
	if ($_POST["vin"] == "") {
	$errors['vin']="<font color='red'>
	Please enter the Vehicle Identification Number.</font>";
	}
}

function display_form () {
	global $errors;
	?>
	<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
	First Name: <br />
	<input type="text" name="first_name" value="<?php echo $_POST[first_name]; ?>"><br />
	<?php echo $errors['first_name']; ?><br />
	Last Name: <br />
	<input type="text" name="last_name" value="<?php echo $_POST[last_name]; ?>"><br />
	<?php echo $errors['last_name']; ?><br />
	Address: <br />
	<input type="text" name="street" value="<?php echo $_POST[street]; ?>"><br />
	<?php echo $errors['street']; ?><br />
	City: <br />
	<input type="text" name="city" value="<?php echo $_POST[city]; ?>"><br />
	<?php echo $errors['city']; ?><br />
	State: <br />
	<input type="text" name="state" value="<?php echo $_POST[state]; ?>"><br />
	<?php echo $errors['state']; ?><br />
	Zip Code: <br />
	<input type="text" name="zip_code" value="<?php echo $_POST[zip_code]; ?>"><br />
	<?php echo $errors['zip_code']; ?><br />
	Vehicle Year: <br />
	<input type="text" name="vehicle_year" value="<?php echo $_POST[vehicle_year]; ?>"><br />
	<?php echo $errors['vehicle_year']; ?><br />
	Vehicle Make: <br />
	<input type="text" name="vehicle_make" value="<?php echo $_POST[vehicle_make]; ?>"><br />
	<?php echo $errors['vehicle_make']; ?><br />
	Vehicle Model: <br />
	<input type="text" name="vehicle_model" value="<?php echo $_POST[vehicle_model]; ?>"><br />
	<?php echo $errors['vehicle_model']; ?><br />
	Vehicle Identification Number: <br />
	<input type="text" name="vin" value="<?php echo $_POST[vin]; ?>"><br />
	<?php echo $errors['vin']; ?><br />
	<input type="reset">
	<input type="submit" name="submit">
	</form>
	<?php
	}

	function preview_form() {
	$first_name=$_POST[first_name];
	$last_name=$_POST[last_name];
	echo "First Name: $first_name </br>";
	echo "Last Name: $last_name";
	?>
	<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
	<input name="go_back" type="submit" value="Go Back">
	<input name="final" type="submit" value="Submit">
	</form>
	<?php
	}

	function submit_final() {
	require ('get_connected.php');
	mysql_query ("INSERT INTO canada (first_name, last_name, street, city, state, zip_code, vehicle_year, vehicle_make, 		                      vehicle_model, vin) " . 
		         "VALUES ('$first_name', '$last_name', '$street', '$city', '$state', '$zip_code', '$vehicle_year',                     '$vehicle_make', '$vehicle_model', '$vin')") or die('Error In Query: '.mysql_error());
	echo "Thank You. Your request has been submitted.";
	}
?>

I can't locate the error or find out why it's adding a blank record. I was also wondering how I would have a timestamp entered? Do I just make a column in MySQL and add then make the type "timestamp"?

Thanks in advance.

aebstract · April 4, 2007

Are you setting those variables that you are trying to insert? I don't see where, but if you aren't that would be a problem.

suttercain · April 4, 2007

Yeah, within the function preview_form

function preview_form() {
	$first_name=$_POST[first_name];
	$last_name=$_POST[last_name];
	$street=$_POST[street];
	$city=$_POST[city];
	$state=$_POST[state];
	$zip_code=$_POST[zip_code];
	$vehicle_year=$_POST[vehicle_year];
	$vehicle_make=$_POST[vehicle_make];
	$vehicle_model=$_POST[vehicle_model];
	$vin=$_POST[vin];
	echo "$first_name $last_name</br>";
	echo "$street</br>";
	echo "$city, $state $zip_code";
	echo "<p>";
	echo "$vehicle_year $vehicle_make $vehicle_model<br>";
	echo "$vin";

Is that not correct or do I have to do it outside of the function?

Thanks.

suttercain · April 4, 2007

They are being set by the form (processed in PHP_SELF):

<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
	First Name: <br />
	<input type="text" name="first_name" value="<?php echo $_POST[first_name]; ?>"><br />
	<?php echo $errors['first_name']; ?><br />
	Last Name: <br />
	<input type="text" name="last_name" value="<?php echo $_POST[last_name]; ?>"><br />
	<?php echo $errors['last_name']; ?><br />
	Address: <br />
	<input type="text" name="street" value="<?php echo $_POST[street]; ?>"><br />
	<?php echo $errors['street']; ?><br />
	City: <br />
	<input type="text" name="city" value="<?php echo $_POST[city]; ?>"><br />
	<?php echo $errors['city']; ?><br />
	State: <br />
	<input type="text" name="state" value="<?php echo $_POST[state]; ?>"><br />
	<?php echo $errors['state']; ?><br />
	Zip Code: <br />
	<input type="text" name="zip_code" value="<?php echo $_POST[zip_code]; ?>"><br />
	<?php echo $errors['zip_code']; ?><br />
	Vehicle Year: <br />
	<input type="text" name="vehicle_year" value="<?php echo $_POST[vehicle_year]; ?>"><br />
	<?php echo $errors['vehicle_year']; ?><br />
	Vehicle Make: <br />
	<input type="text" name="vehicle_make" value="<?php echo $_POST[vehicle_make]; ?>"><br />
	<?php echo $errors['vehicle_make']; ?><br />
	Vehicle Model: <br />
	<input type="text" name="vehicle_model" value="<?php echo $_POST[vehicle_model]; ?>"><br />
	<?php echo $errors['vehicle_model']; ?><br />
	Vehicle Identification Number: <br />
	<input type="text" name="vin" value="<?php echo $_POST[vin]; ?>"><br />
	<?php echo $errors['vin']; ?><br />
	<input type="reset">
	<input type="submit" name="submit">
	</form>

I can't figure out why it's just inserting a blank record.

suttercain · April 4, 2007

Can anyone tell me if the code looks correct to them even if you may not have an answer?

Thanks.

kenrbnsn · April 4, 2007

Variables set inside a function are only available to that function, not outside of it.

Ken

suttercain · April 4, 2007

Hi Ken,

Thank you for your reply. I just attempted to set the variables within the function:

if(isset($_REQUEST['final'])){
   		//submit_final();
	$first_name=$_POST[first_name];
	$last_name=$_POST[last_name];
	$street=$_POST[street];
	$city=$_POST[city];
	$state=$_POST[state];
	$zip_code=$_POST[zip_code];
	$vehicle_year=$_POST[vehicle_year];
	$vehicle_make=$_POST[vehicle_make];
	$vehicle_model=$_POST[vehicle_model];
	$vin=$_POST[vin];
	require ('get_connected.php');
	mysql_query ("INSERT INTO canada (first_name, last_name, street, city, state, zip_code, vehicle_year, vehicle_make, vehicle_model, vin)  VALUES ('$first_name', '$last_name', '$street', '$city', '$state', '$zip_code', '$vehicle_year', '$vehicle_make', '$vehicle_model', '$vin')") or die('Error In Query: '.mysql_error());

	echo "Thank You. Your request has been submitted.";
	}

And I am getting the same results. An empty record is being inserted into the database.

kenrbnsn · April 4, 2007

Change the code to

<?php
if(isset($_REQUEST['final'])){
   echo '<pre>' . print_r($_POST,true) . '</pre>';
   		//submit_final();
	$first_name=$_POST['first_name'];
	$last_name=$_POST['last_name'];
	$street=$_POST['street'];
	$city=$_POST['city'];
	$state=$_POST['state'];
	$zip_code=$_POST['zip_code'];
	$vehicle_year=$_POST['vehicle_year'];
	$vehicle_make=$_POST['vehicle_make'];
	$vehicle_model=$_POST['vehicle_mode'l];
	$vin=$_POST['vin'];
	require ('get_connected.php');
	$q ="INSERT INTO canada (first_name, last_name, street, city, state, zip_code, vehicle_year, vehicle_make, vehicle_model, vin)  VALUES ('$first_name', '$last_name', '$street', '$city', '$state', '$zip_code', '$vehicle_year', '$vehicle_make', '$vehicle_model', '$vin')";
                echo 'About to do query <pre>$q</pre>';
                $rs = mysql_query($q) or die("Error In Query: <pre>$q</pre><br>".mysql_error());

	echo "Thank You. Your request has been submitted.";
	}
?>

I put in some debug statements.

Ken

suttercain · April 4, 2007

Thanks again Ken,

I tried the code and after I submitted the for it inserted a blank record into the database and printed out the following:

Array

(

[final] => Submit

)

About to do query

$q

Thank You. Your request has been submitted.

Here is the full code I am working with:

<?php
session_start();
?>
<html><head><title>Empty Fields</title></head>
<body>
<?php
  $errors=array();
  if(isset($_REQUEST['submit'])){ // If the form was submitted
     validate_input(); // Check for empty fields
     if(count($errors) != 0){ // If there are errors,
      // redisplay the form
         display_form();
     }
     else{ preview_form(); }
   }
   else{display_form();} // Display the form for the first time
   

if(isset($_REQUEST['final'])){
   echo '<pre>' . print_r($_POST,true) . '</pre>';
   		//submit_final();
	$first_name=$_POST['first_name'];
	$last_name=$_POST['last_name'];
	$street=$_POST['street'];
	$city=$_POST['city'];
	$state=$_POST['state'];
	$zip_code=$_POST['zip_code'];
	$vehicle_year=$_POST['vehicle_year'];
	$vehicle_make=$_POST['vehicle_make'];
	$vehicle_model=$_POST['vehicle_mode'];
	$vin=$_POST['vin'];
	require ('get_connected.php');
	$q ="INSERT INTO canada (first_name, last_name, street, city, state, zip_code, vehicle_year, vehicle_make, vehicle_model, vin)  VALUES ('$first_name', '$last_name', '$street', '$city', '$state', '$zip_code', '$vehicle_year', '$vehicle_make', '$vehicle_model', '$vin')";
                echo 'About to do query <pre>$q</pre>';
                $rs = mysql_query($q) or die("Error In Query: <pre>$q</pre><br>".mysql_error());

	echo "Thank You. Your request has been submitted.";
	}


if($_REQUEST['go_back']){
	validate_input();
	}

function validate_input(){
	global $errors;
	if ($_POST["first_name"] == "") {
	$errors['first_name']="<font color='red'>*</font>";
	}
	if ($_POST["last_name"] == "") {
	$errors['last_name']="<font color='red'>
	Please enter your Last Name.</font>";
	}
	if ($_POST["street"] == "") {
	$errors['street']="<font color='red'>
	Please enter your Street Address.</font>";
	}
	if ($_POST["city"] == "") {
	$errors['city']="<font color='red'>
	Please enter your City.</font>";
	}
	if ($_POST["state"] == "") {
	$errors['state']="<font color='red'>
	Please select your State.</font>";
	}
	if ($_POST["zip_code"] == "") {
	$errors['zip_code']="<font color='red'>
	Please enter your Zip Code.</font>";
	}
	if ($_POST["vehicle_year"] == "") {
	$errors['vehicle_year']="<font color='red'>
	Please enter the Year of the Vehicle.</font>";
	}
	if ($_POST["vehicle_make"] == "") {
	$errors['vehicle_make']="<font color='red'>
	Please enter the Make of the Vehicle.</font>";
	}
	if ($_POST["vehicle_model"] == "") {
	$errors['vehicle_model']="<font color='red'>
	Please enter the Model of the Vehicle.</font>";
	}
	if ($_POST["vin"] == "") {
	$errors['vin']="<font color='red'>
	Please enter the Vehicle Identification Number.</font>";
	}
}

function display_form () {
	global $errors;
	?>
	<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
	First Name:<?php echo $errors['first_name']; ?> <br />
	<input type="text" name="first_name" value="<?php echo $_POST[first_name]; ?>"><br /><br>
	Last Name: <br />
	<input type="text" name="last_name" value="<?php echo $_POST[last_name]; ?>"><br />
	<?php echo $errors['last_name']; ?><br />
	Address: <br />
	<input type="text" name="street" value="<?php echo $_POST[street]; ?>"><br />
	<?php echo $errors['street']; ?><br />
	City: <br />
	<input type="text" name="city" value="<?php echo $_POST[city]; ?>"><br />
	<?php echo $errors['city']; ?><br />
	State: <br />
	<input type="text" name="state" value="<?php echo $_POST[state]; ?>"><br />
	<?php echo $errors['state']; ?><br />
	Zip Code: <br />
	<input type="text" name="zip_code" value="<?php echo $_POST[zip_code]; ?>"><br />
	<?php echo $errors['zip_code']; ?><br />
	Vehicle Year: <br />
	<input type="text" name="vehicle_year" value="<?php echo $_POST[vehicle_year]; ?>"><br />
	<?php echo $errors['vehicle_year']; ?><br />
	Vehicle Make: <br />
	<input type="text" name="vehicle_make" value="<?php echo $_POST[vehicle_make]; ?>"><br />
	<?php echo $errors['vehicle_make']; ?><br />
	Vehicle Model: <br />
	<input type="text" name="vehicle_model" value="<?php echo $_POST[vehicle_model]; ?>"><br />
	<?php echo $errors['vehicle_model']; ?><br />
	Vehicle Identification Number: <br />
	<input type="text" name="vin" value="<?php echo $_POST[vin]; ?>"><br />
	<?php echo $errors['vin']; ?><br />
	<input type="reset">
	<input type="submit" name="submit">
	</form>
	<?php
	}

	function preview_form() {
	$first_name=$_POST[first_name];
	$last_name=$_POST[last_name];
	$street=$_POST[street];
	$city=$_POST[city];
	$state=$_POST[state];
	$zip_code=$_POST[zip_code];
	$vehicle_year=$_POST[vehicle_year];
	$vehicle_make=$_POST[vehicle_make];
	$vehicle_model=$_POST[vehicle_model];
	$vin=$_POST[vin];
	echo "$first_name $last_name</br>";
	echo "$street</br>";
	echo "$city, $state $zip_code";
	echo "<p>";
	echo "$vehicle_year $vehicle_make $vehicle_model<br>";
	echo "$vin";
	?>
	<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
	<input name="go_back" type="submit" value="Go Back">
	<input name="final" type="submit" value="Submit">
	</form>
	<?php
	}

	/*function submit_final() {
	require ('get_connected.php');
	mysql_query ("INSERT INTO canada (first_name, last_name, street, city, state, zip_code, vehicle_year, vehicle_make, 		                      vehicle_model, vin)  VALUES ('$first_name', '$last_name', '$street', '$city', '$state', '$zip_code', 	  		'$vehicle_year', '$vehicle_make', '$vehicle_model', '$vin')") or die('Error In Query: '.mysql_error());

	echo "Thank You. Your request has been submitted.";
	} */
?>
</body>
</html>

I should explain the setup also. It's a basic form. If the user leaves any field blank they get a red error telling the to fill it in. If all fields have been filled it it takes them to the preview_form (PHP_SELF) and then they can view the data they entered. If it's all good they hit the submit button (final) and it should ideally enter their information into the database or if there is an error they can hit go back and it takes them to the form before submitting it to the database.

kenrbnsn · April 4, 2007

This

Array
(
    [final] => Submit
)

means that the values from your form are not being posted to your processing script.

I goofed on the other echo, change it to

<?php
echo "About to do query <pre>$q</pre>";
?>

Ken

suttercain · April 4, 2007

Ah... you're right. it echoed:

About to do query

INSERT INTO canada (first_name, last_name, street, city, state, zip_code, vehicle_year, vehicle_make, vehicle_model, vin)  VALUES ('', '', '', '', '', '', '', '', '', '')

Thanks. I see now that the values are empty, I just don't know why. I defined them... or at least I thought I did.

yzerman · April 4, 2007

Use the following when defining your variables

if (isset($_POST['name']) {
   $name = $_POST['name'];
} else {
   $name = NULL;
}
///...check the rest of your variables this way

Then before the query ($q):

//see if your variables are set, if not, the statement will return FALSE
if ($name && $var2 && $var3) {
  $q = "INSERT ..."
} else {
  echo 'One or more of your variables are not set'
  echo 'Name = $name\n';
  echo 'Var2 = $var2\n'; //add one of these for each variable
}

Also, you are putting your form into a function. While I am not sure - I do believe that $_SERVER['PHP_SELF'] within a function will return http://www.url.com/yourscript?yourFunction.

It might be better to remove the function, and place the form after the closing tags of PHP:

?>

<form>...

kenrbnsn · April 4, 2007

Also, you are putting your form into a function. While I am not sure - I do believe that $_SERVER['PHP_SELF'] within a function will return http://www.url.com/yourscript?yourFunction.

That is not true. The $_SERVER superglobal array doesn't change whether you're in a function or not.

Ken

suttercain · April 4, 2007

Hi Yzerman,

Thanks for the reply, I am going on my second day with this code.

Question, this is the if statement that contains my MySQL query and what I thought was the defining of the variables:

if(isset($_REQUEST['final'])){
   echo '<pre>' . print_r($_POST,true) . '</pre>';
   		//submit_final();
	$first_name=$_POST['first_name'];
	$last_name=$_POST['last_name'];
	$street=$_POST['street'];
	$city=$_POST['city'];
	$state=$_POST['state'];
	$zip_code=$_POST['zip_code'];
	$vehicle_year=$_POST['vehicle_year'];
	$vehicle_make=$_POST['vehicle_make'];
	$vehicle_model=$_POST['vehicle_mode'];
	$vin=$_POST['vin'];
	require ('get_connected.php');
	$q ="INSERT INTO canada (first_name, last_name, street, city, state, zip_code, vehicle_year, vehicle_make, vehicle_model, vin)  VALUES ('$first_name', '$last_name', '$street', '$city', '$state', '$zip_code', '$vehicle_year', '$vehicle_make', '$vehicle_model', '$vin')";
                echo "About to do query <pre>$q</pre>";
                $rs = mysql_query($q) or die("Error In Query: <pre>$q</pre><br>".mysql_error());

	echo "Thank You. Your request has been submitted.";
	}

About your first code, "Use the following when defining your variables", do I create the if statement(s) with the if(isset($_REQUEST['final'])) statement? I am going bonkers.... like the candy from the 80's.

Thanks again.

kenrbnsn · April 4, 2007

Found your problem.

You have two separate forms. The first to get all the information, the second for verification. When you submit the second, the values from the first are lost. You need to either set all the values in hidden fields or put them into session variables.

Also, I would change any reference to $_REQUEST to $_POST.

Ken

suttercain · April 4, 2007

Ahhh Sessions.... I can start to see it now. I will give that a shot.

Will change to $_REQUEST to $_POST now. Security I assume?

Thanks. I'll try sessions after lunch.

Shannon

kenrbnsn · April 4, 2007

The $_REQUEST array contains all the variables from the $_GET, $_POST, and $_COOKIE arrays. If you have the same variable defined in more than one array, you can't be sure of which one you're getting.

It's almost as bad (IMHO) as register_globals being enabled.

Ken

suttercain · April 4, 2007

Would setting the variables as global work?

yzerman · April 4, 2007

This is how I prefer to do a form:

<?php
//check that the form has been submitted, otherwise we do nothing
if (isset($_POST['submit'])) { //Form submission button pressed
// Check for a first name.
if (eregi ("^[[:alpha:].' -]{2,15}$", stripslashes(trim($_POST['first_name'])))) { //I suggest you use eregi for the rest of your form as well - meow - I just didnt have time to do every field for you
	$fn = $_POST['first_name'];
} else {
	$fn = FALSE;
	echo 'Please enter your first name!<br />';
}
if (!empty($_POST['last_name'])) {
	$ln = $_POST['last_name'];
} else {
	$ln = FALSE;
	echo 'You Must enter a last name!<br />';
}
if (!empty($_POST['street'])) {
	$s = $_POST['street'];
} else {
	$s = FALSE;
	echo 'Street is a required field!<br />';
}
if (!empty($_POST['city'])) {
	$c = $_POST['city'];
} else {
	$c = FALSE;
	echo 'You must enter a city!<br />';
}
if (!empty($_POST['state'])) {
	$sta = $_POST['state'];
} else {
	$sta = FALSE;
	echo 'You must enter a state!<br />';
}
if (!empty($_POST['zip_code'])) {
	$zc = $_POST['zip_code'];
} else {
	$zc = FALSE;
	echo 'You must enter a zip code meow!<br />';
}
if (!empty($_POST['vehicle_year'])) {
	$y = $_POST['vehicle_year'];
} else {
	$y = FALSE;
	echo 'You must enter a year for your ride! (You do have a ride don\'t you?)<br />';
}
if (!empty($_POST['vehicle_make'])) {
	$m = $_POST['make'];
} else {
	$m = FALSE;
	echo 'You have to enter the make of your vehicle (Thats the company who <b>makes</b> your ride meow)<br />';
}
if (!empty($_POST['vehicle_model'])) {
	$mod = $_POST['vehicle_model'];
} else {
	$mod = FALSE;
	echo 'You must enter the model of your vehicle (No were not talking about Jessica Simpson!)<br />';
}
if (!empty($_POST['vin'])) {
	$vin = $_POST['vin'];
} else {
	$vin = FALSE;
	echo 'This is where we make sure you REALLY have a ride, the VIN number is required - A VIN is composed of 17 digits and characters that act as a unique identifier for the vehicle. Meow. A VIN displays the car\'s unique features, specifications and manufacturer.<br />';
}
//ok, now that thats done, lets check to see if they are all set 
if ($fn && $ln && $s && $c && $sta && $zc && $y && $m && $mod && $vin) { //all set meow?
	$q = "INSERT INTO table (first_name, last_name, street, city, state, zip_code, year, make, model, vin) VALUES ('$fn','$ln','$s','$c','$sta','$zc','$y', '$m', '$mod', '$vin');";
	$result = mysql_query($q);
	if ($result) { //if the query went ok
		echo 'Thanks for submitting my form!';
	} else { // something went wrong with the query
		echo 'Something went wrong with the query - Please try again<br /> The error that was returned is: ' . mysql_error($result);
	}
} else { //something went wrong with the form (variable isn't set)
	echo 'There was an error submitting your form!';
}
} //end submit continual 
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
	First Name: <br />
	<input type="text" name="first_name" value="<?php echo $_POST['first_name']; ?>"><br />
	Last Name: <br />
	<input type="text" name="last_name" value="<?php echo $_POST['last_name']; ?>"><br />
	Address: <br />
	<input type="text" name="street" value="<?php echo $_POST['street']; ?>"><br />
	City: <br />
	<input type="text" name="city" value="<?php echo $_POST['city']; ?>"><br />
	State: <br />
	<input type="text" name="state" value="<?php echo $_POST['state']; ?>"><br />
	Zip Code: <br />
	<input type="text" name="zip_code" value="<?php echo $_POST['zip_code']; ?>"><br />
	Vehicle Year: <br />
	<input type="text" name="vehicle_year" value="<?php echo $_POST['vehicle_year']; ?>"><br />
	Vehicle Make: <br />
	<input type="text" name="vehicle_make" value="<?php echo $_POST['vehicle_make']; ?>"><br />
	Vehicle Model: <br />
	<input type="text" name="vehicle_model" value="<?php echo $_POST['vehicle_model']; ?>"><br />
	Vehicle Identification Number: <br />
	<input type="text" name="vin" value="<?php echo $_POST['vin']; ?>"><br />meow!<br />
	<input type="reset">
	<input type="submit" name="submit" value="submit">
	</form>

suttercain · April 4, 2007

Ken you're the man!!!!! I used hidden fields in the form and boo-yah, it works. Thank you very much for your help.

Shannon

Sign In

[SOLVED] MySQL INSERT command adding a blank record

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information