# Error, query failed: Column Count Does not match value count at row 1

**URL:** <https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067>\
**Category:** General Database (Oracle, SQL Server, etc)\
**Created:** [April 9, 2011, 9:54pm UTC](https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067 "2011-04-09T21:54:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bartalen](https://www.phphelp.com/letter_avatar_proxy/v4/letter/b/71e660/32.png) [@bartalen](https://www.phphelp.com/u/bartalen)\
**Post date:** [April 9, 2011, 9:54pm UTC](https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067/1 "2011-04-09T21:54:22Z")

</div>

Form File

```auto
<link href="formstijl.css" rel="stylesheet" type="text/css">
<h1>
  <legend>Nieuw Product:</legend>
</h1>
<?php
include 'db_config.php';
?>
<div id="stylized" class="formstyle-1">
<form action="/procces/proc_add_product.php" method="POST" enctype="multipart/form-data">
  <p>Velden gemarkeerd met <em>*</em> zijn verplicht!</p>
  <fieldset>
         <label for="product">Naam het product<em>*</em>
                  <span class="small">Verplicht veld</span></label>
                  <input id="product" name="product" />

<?php
$result = @mysql_query("SELECT categorie FROM producten_categorie");

echo '<label for="categorie">Categorie</label>';
echo '<select name="categorie">'.PHP_EOL;
while ($row = mysql_fetch_assoc($result))
{
	  echo '<option value="'.$row['categorie'].'">'.$row['categorie'].'</option>'.PHP_EOL;
}        
echo '</select>'.PHP_EOL;
echo '</p>'.PHP_EOL;
?>
      
 <?php
$result = @mysql_query("SELECT leverancier FROM producten_leverancier");

echo '<label for="leverancier">Leverancier</label>';
echo '<select name="leverancier">'.PHP_EOL;
while ($row = mysql_fetch_assoc($result))
{
	  echo '<option value="'.$row['leverancier'].'">'.$row['leverancier'].'</option>'.PHP_EOL;
}        
echo '</select>'.PHP_EOL;
echo '</p>'.PHP_EOL;
?>

                  
        <label for="beschrijving">Beschrijving</label>
    			  <textarea id="beschrijving" name="beschrijving"></textarea>
                  
<?php
$result = @mysql_query("SELECT verpakking FROM producten_verpakking");

echo '<label for="verpakking">Verpakking</label>';
echo '<select name="verpakking">'.PHP_EOL;
while ($row = mysql_fetch_assoc($result))
{
	  echo '<option value="'.$row['verpakking'].'">'.$row['verpakking'].'</option>'.PHP_EOL;
}        
echo '</select>'.PHP_EOL;
echo '</p>'.PHP_EOL;
?>

<?php
$result = @mysql_query("SELECT eenheid FROM producten_eenheid");

echo '<label for="eenheid">E&eacute;nheid</label>';
echo '<select name="eenheid">'.PHP_EOL;
while ($row = mysql_fetch_assoc($result))
{
	  echo '<option value="'.$row['eenheid'].'">'.$row['eenheid'].'</option>'.PHP_EOL;
}        
echo '</select>'.PHP_EOL;
echo '</p>'.PHP_EOL;
?>

        <label for="opmerking">Opmerking</label>
    			  <textarea id="opmerking" name="opmerking"></textarea>
    
        <label for="product_url">Meer info<em></em>
                  <span class="small">voorafgaande van http://</span></label>      
                  <input id="product_url" name="product_url" />

        <label for="order_url">Bestellen<em></em>
                  <span class="small">voorafgaande van http://</span></label>
                  <input id="order_url" name="order_url" />

        <label for="file">Logo<em></em>
                  <span class="small">Max. 4mb</span></label>
                   <input name="userfile" type="file" id="userfile">

    <input name="upload" type="submit" class="box" id="upload" value=" Verzenden ">
    <div class="spacer"></div>
  </fieldset>
</form>
</div>
```

procces file

```auto
<?php
ini_set('display_errors', 'On');
error_reporting(E_ALL | E_STRICT);
if ($_SERVER['REQUEST_METHOD'] == "POST") 
 // Configuratie
$allowed_filetypes = array('.jpg','.jpeg','.gif','.bmp','.png');
$max_filesize = 4194304; // 4mb
$upload_path = '../images/producten/'; 

$filename = $_FILES['userfile']['name']; // Verkrijg userfilesnaam en extentie.
$ext = substr($filename, strpos($filename,'.'), strlen($filename)-1); // Verkrijg userfile extentie.
 
// Bekijk of het bestandsextentie is toegelaten.
if(!in_array($ext,$allowed_filetypes))
	die('Bestandsextentie is niet toegelaten.');

// Nakijken van de max_filesize.
if(filesize($_FILES['userfile']['tmp_name']) > $max_filesize)
	die('Het bestand is te groot.');

// nakijken of de doelmap schrijfbaar is.
if(!is_writable($upload_path))
	die('Doelmap is niet schrijfbaar, gelieven de CHMOD te veranderen naar 777.');

// Bestandscontrole op identieke namen.
if (file_exists("$upload_path" . "$filename")) { 
$random_digit=rand(0000,9999);
$filename=$random_digit.$filename;
}
else {
$filename = $_FILES['userfile']['name'];
}
// Directory target.
$target = $upload_path .$filename;

// Schrijf data naar mysql database.
include '../db_config.php';
	$fileName = $_FILES['userfile']['name'];
	$tmpName = $_FILES['userfile']['tmp_name'];
	$fileSize = $_FILES['userfile']['size'];
	$fileType = $_FILES['userfile']['type'];
	$query = "INSERT INTO producten_leverancier (product, categorie, leverancier, beschrijving, eenheid, verpakking, opmerking, product_url, order_url, name, size, type, path)".
	 	     "VALUES ('".mysql_real_escape_string($_POST['product'])."',
				   	  '".mysql_real_escape_string($_POST['categorie'])."',
					  '".mysql_real_escape_string($_POST['leverancier'])."',
					  '".mysql_real_escape_string($_POST['beschrijving'])."',
					  '".mysql_real_escape_string($_POST['opmerking'])."',
					  '".mysql_real_escape_string($_POST['verpakking'])."'
					  '".mysql_real_escape_string($_POST['eenheid'])."'
					  '".mysql_real_escape_string($_POST['product_url'])."'
					  '".mysql_real_escape_string($_POST['order_url'])."'
					  '".mysql_real_escape_string($fileName)."',
              		  '".mysql_real_escape_string($fileSize)."',
              		  '".mysql_real_escape_string($fileType)."',
              		  '".mysql_real_escape_string($upload_path . $filename)."')";  

		mysql_query($query) or die('Error, query failed : ' . mysql_error());
include '../db_close.php';

// Upload het bestand.
if(move_uploaded_file($_FILES['userfile']['tmp_name'], $target))
{

// Slot besluit.
echo "De ingevoerde gegevens zijn correct verstuurd.";
}
else {
  echo "<p>Er heeft zich een onbekende fout voorgedaan!</p>\n";
  }
?>
```

Thanx in advance

---

<div class="post-metadata">

**Author:** ![phphelp](https://www.phphelp.com/letter_avatar_proxy/v4/letter/p/3ec8ea/32.png) [@phphelp](https://www.phphelp.com/u/phphelp)\
**Post date:** [April 9, 2011, 10:13pm UTC](https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067/2 "2011-04-09T22:13:16Z")

</div>

You are missing several commas in these lines (just append similar to what you have for other fields in this query):  
[php]’".mysql\_real\_escape\_string($\_POST[‘verpakking’])."’  
‘".mysql\_real\_escape\_string($\_POST[‘eenheid’])."’  
‘".mysql\_real\_escape\_string($\_POST[‘product\_url’])."’  
‘".mysql\_real\_escape\_string($\_POST[‘order\_url’])."’[/php]

---

<div class="post-metadata">

**Author:** ![bartalen](https://www.phphelp.com/letter_avatar_proxy/v4/letter/b/71e660/32.png) [@bartalen](https://www.phphelp.com/u/bartalen)\
**Post date:** [April 9, 2011, 10:28pm UTC](https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067/3 "2011-04-09T22:28:30Z")

</div>

> [@phphelp](#):
>
> You are missing several commas in these lines (just append similar to what you have for other fields in this query):  
> [php]‘“.mysql\_real\_escape\_string($\_POST[‘verpakking’]).”’  
> ‘“.mysql\_real\_escape\_string($\_POST[‘eenheid’]).”’  
> ‘“.mysql\_real\_escape\_string($\_POST[‘product\_url’]).”’  
> ‘“.mysql\_real\_escape\_string($\_POST[‘order\_url’]).”’[/php]

Stupid of me, just when i get this message… ive seen it also…

Kind regards

---

<div class="post-metadata">

**Author:** ![bartalen](https://www.phphelp.com/letter_avatar_proxy/v4/letter/b/71e660/32.png) [@bartalen](https://www.phphelp.com/u/bartalen)\
**Post date:** [April 9, 2011, 10:34pm UTC](https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067/4 "2011-04-09T22:34:06Z")

</div>

But i’m still stuck here

Notice: Undefined index: userfile in /home/pockta/domains/pockta.com/public\_html/procces/proc\_add\_product.php on line 10

Notice: Undefined variable: allowed\_filetypes in /home/pockta/domains/pockta.com/public\_html/procces/proc\_add\_product.php on line 14

Warning: in\_array() [function.in-array]: Wrong datatype for second argument in /home/pockta/domains/pockta.com/public\_html/procces/proc\_add\_product.php on line 14  
Bestandsextentie is niet toegelaten.

---

<div class="post-metadata">

**Author:** ![phphelp](https://www.phphelp.com/letter_avatar_proxy/v4/letter/p/3ec8ea/32.png) [@phphelp](https://www.phphelp.com/u/phphelp)\
**Post date:** [April 10, 2011, 8:41am UTC](https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067/5 "2011-04-10T08:41:20Z")

</div>

Undefined index userfile - is becasue your $\_FILES array seem have no such index set. This happen if you call this script but not posting file named ‘userfile’ to it. To fix this, you need to check if files were submitted, like this:

[php]if(is\_uploaded\_file($\_FILES[“userfile”][“tmp\_name”]){

// … your code here

}  
else{  
if($\_SERVER[“REQUEST\_METHOD”]==‘POST’ and $\_POST[‘upload’]) echo ‘Please upload file!’;  
}  
[/php]

The other two error messages follows from this first.

---

<div class="post-metadata">

**Author:** ![bartalen](https://www.phphelp.com/letter_avatar_proxy/v4/letter/b/71e660/32.png) [@bartalen](https://www.phphelp.com/u/bartalen)\
**Post date:** [April 10, 2011, 2:34pm UTC](https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067/6 "2011-04-10T14:34:15Z")

</div>

The problem is solved,

I have defined the table name wrong…  
thankx