Problem with insert statement

rfigley

This script will not insert the data from my form into the MySql database. I'm using the echo statements to verify two the data fields that's supposed to be inserted and that is correct. But I keep getting the "unable to Insert Data". Any ideas?

As a note, the columns are not specified so that it defaults to inserting all columns.

<?php
include ("dbconnect_test.php");
  echo "<BR>";
  echo "Receives ($name)"; echo "Receives ($chapter)";
  echo "<BR>";
mysql_query ("INSERT INTO tbl_members",$db)
       or die ("unable to Insert Data");


?>

scoppc

You didn't insert anything to the table since your INSERT INTO statement is incomplete.

You should do the following:

$sql="INSERT INTO tableName VALUES('$one','$two')";
$query=mysql_query($sql);

rfigley

OK, here's where I'm at:

$query = ("insert into tbl_members values
   ('$name','$chapter','$position','$category','$business_name','$address1','$address2','$city','$state','$zip','$phone','$fax','$e_mail','$web_address')")
   or die ("unable to Insert Data");
   $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

Using the error statement I'm getting ther error:

Error in query: insert into tbl_members values ('Name','chapter','position','category','business','address1','address2','city','st','zip','phone','fax','email','web address'). Column count doesn't match value count at row 1

SKennedy

First, the first 'or die' statement is worthless.

Second, you are passing the values to insert, but not the row names to insert them too. If you just want the defaults of the rows, get rid of the 'VALUES' word in your insert statement, and see if that works ( it might not ). If it doesn't you'll need to pass it null data ( '' ) as the values, and it will then load the defaults.

Lars_Berg

If you don't insert values into all columns in the table you need to specify a list of which columns you insert into. That's what the error messages says, the number of values in not the same as the number of columns in the table.

$query = ("insert into tbl_members (name,chapter,position,category,business_name,address1,address2,city,state,zip,phone,fax,e_mail,web_address) values
    ('$name','$chapter','$position','$category','$busi
 ness_name','$address1','$address2','$city','$state
 ','$zip','$phone','$fax','$e_mail','$web_address')

I just guessed the column names, so adapt accordingly to your table definition.