[SOLVED] ERROR::Could not insert record: Column count doesn't match value count at row1??

[cluce]

I am not sure wants going on here. Both of my fields are varchar(50). Can someone tell me what I am missing?

 

here is the code I am using.........

 

<?php

$mysqli = mysqli_connect("localhost", "root", "", "test");

 

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit();

} else {

$sql = "INSERT INTO testTable (testField) VALUES ('".$_POST['testfield']."','".$_POST['testfield2']."')";

$res = mysqli_query($mysqli, $sql);

 

if ($res === TRUE) {

  echo "A record has been inserted.";

} else {

printf("Could not insert record: %s\n", mysqli_error($mysqli));

}

 

mysqli_close($mysqli);

}

?>

 

[papaface]

you have two values for one column name:

INSERT INTO testTable (testField) VALUES ('".$_POST['testfield']."','".$_POST['testfield2']."')"

[cluce]

duhh me, thanks.