Column count doesn't match value count at row 1

D

DirectX

Registered
Знам, че е нещо елементарно, но не мога да си открия грешката ...
PHP: 
<form method="post" action="">
<table width="1244" height="90" border="1">
  <tr>
    <td>Номер на имот</td>
    <td>Землище</td>
    <td>Площ</td>
    <td>Местност</td>
    <td>Рента </td>
    <td>Култура</td>
    <td>Заявка</td>
    <td>Рента</td>
    <td>Обработено</td>
    <td>Бележка</td>
  </tr>
  <tr>
    <td><input type="text" name="nomer_imot" id="nomer_imot" /></td>
    <td>
     	<select name="zemlishte" id="zemlishte">
          <option>Сливен</option>
          <option>Речица</option>
          <option>с. Мечкарево</option>
          <option>с. Тополчане</option>
          <option>с. Камен</option>
    </select></td>
    <td><input type="text" name="plosht" id="plosht" /></td>
    <td><input type="text" name="mestnost" id="mestnost" /></td>
    <td><input type="text" name="renta_kg" id="renta_kg" /></td>
    <td><input type="text" name="kultura" id="kultura" /></td>
    <td>
      <select name="zaqvka" id="zaqvka">
        <option>Да</option>
        <option>Не</option>
      </select></td>
    <td>
      <select name="renta" id="renta">
      <option>Да</option>
        <option>Не</option>
      </select></td>
    <td>
      <select name="obraboteno" id="obraboteno">
      <option>Да</option>
        <option>Не</option>
      </select></td>
    <td><input type="text" name="belejka" id="belejka" /></td>
  </tr>
</table>
<input name="submit" type="submit" id="button" value="Добави" />
</form>
<p>
  <?php

include 'connect.db.php';

if(isset($_POST['submit'])){

	$s_id = $_GET['id'];
	$nomer_imot = trim(strip_tags(addslashes($_POST['nomer_imot'])));
	$zemlishte = trim(strip_tags(addslashes($_POST['zemlishte'])));
	$plosht = trim(strip_tags(addslashes($_POST['plosht'])));
	$mestnost = trim(strip_tags(addslashes($_POST['mestnost'])));
	$renta_kg = trim(strip_tags(addslashes($_POST['renta_kg'])));
	$kultura = trim(strip_tags(addslashes($_POST['kultura'])));
	$zaqvka = trim(strip_tags(addslashes($_POST['zaqvka'])));
	$renta = trim(strip_tags(addslashes($_POST['renta'])));
	$obraboteno = trim(strip_tags(addslashes($_POST['obraboteno'])));
	$belejka = trim(strip_tags(addslashes($_POST['belejka'])));
	

$proverka = mysql_query("SELECT * FROM `zemq` WHERE `nomer_imot`='$nomer_imot'")or(mysql_error()); //проверка да ли съществува
if (mysql_num_rows($proverka) > 0) {
echo "<script type=\"text/javascript\">alert('Такъв номер има въвведен в базата данни')</script>"; 
} else {
	$sql = "INSERT INTO `zemq` (`id`, `s_id`, `nomer_imot`, `zemlishte`, `plosht`, `mestnost`, `renta_kg`, `kultura`, `zaqvka`, `renta`, `obraboteno`, `belejka`)
						VALUES (NULL, '$s_id', '$nomer_imot', '$zemlishte' '$plosht', '$mestnost', '$renta_kg', '$kultura', '$zaqvka', '$renta', '$obraboteno', '$belejka');"; 
	$result = mysql_query($sql)or die(mysql_error()."<br />Грешка: ".__LINE__);
if($result == true){
echo '<meta http-equiv="refresh" content="1;url=informaciq.php?id='.$s_id.'">';	
echo "Моля почакайте страницата да презареди...";
}
else {
echo "възникна грешка..";
}}}
?>

[sql]CREATE TABLE `zemq` (
`id` int(11) NOT NULL auto_increment,
`s_id` int(11) NOT NULL,
`nomer_imot` varchar(40) NOT NULL,
`zemlishte` varchar(40) NOT NULL,
`plosht` varchar(40) NOT NULL,
`mestnost` varchar(40) NOT NULL,
`renta_kg` varchar(40) NOT NULL,
`kultura` varchar(40) NOT NULL,
`zaqvka` varchar(40) NOT NULL,
`renta` varchar(40) NOT NULL,
`obraboteno` varchar(40) NOT NULL,
`belejka` text(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM ;
[/sql][/sql]
 
изпуснал зи запетайката след '$zemlishte'

VALUES (NULL, '$s_id', '$nomer_imot', '$zemlishte' ,'$plosht', '$mestnost', '$renta_kg', '$kultura', '$zaqvka', '$renta', '$obraboteno', '$belejka');";
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе