помощ за заявка за БД

M

macmen

Registered
Имам следния проблем "Column count doesn't match value count at row 1"
Моля помогнете ми да открия грешката

това ми е БД:

Код: 
CREATE TABLE IF NOT EXISTS `parvi` (
  `id` int(10) NOT NULL,
  `vrazka` varchar(250) collate utf8_unicode_ci NOT NULL,
  `date` varchar(250) collate utf8_unicode_ci NOT NULL,
  `izgotvil` varchar(250) collate utf8_unicode_ci NOT NULL,
  `join` varchar(250) collate utf8_unicode_ci NOT NULL,
  `edno` varchar(255) collate utf8_unicode_ci NOT NULL,
  `edno_edno` varchar(250) collate utf8_unicode_ci NOT NULL,
  `edno_dve` varchar(250) collate utf8_unicode_ci NOT NULL,
  `edno_tri` varchar(250) collate utf8_unicode_ci NOT NULL,
  `ob6to_edno` varchar(250) collate utf8_unicode_ci NOT NULL,
  `edno_n_g` varchar(250) collate utf8_unicode_ci NOT NULL,
  `edno_edno_n_g` varchar(250) collate utf8_unicode_ci NOT NULL,
  `edno_dve_n_g` varchar(250) collate utf8_unicode_ci NOT NULL,
  `edno_tri_n_g` varchar(250) collate utf8_unicode_ci NOT NULL,
  `ob6to_n_g` varchar(250) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Дъмп (схема) на данните в таблицата `parvi`
--

INSERT INTO `parvi` (`id`, `vrazka`, `date`, `izgotvil`, `join`, `edno`, `edno_edno`, `edno_dve`, `edno_tri`, `ob6to_edno`, `edno_n_g`, `edno_edno_n_g`, `edno_dve_n_g`, `edno_tri_n_g`, `ob6to_n_g`) VALUES
(1, 'yes', '', '', '', '4', '4', '4', '4', '16', '18', '18', '19', '20', '91'),
(2, 'no', '', '', '', '123', '123', '123', '123', '123', '123', '123', '123', '123', '101');







И кода:



Код: 
if(isset($_POST['submit'])){
 		 	
$aa = $_POST['edno_n_g']; 
$bb = $_POST['edno_edno_n_g'];
$cc = $_POST['edno_dve_n_g'] ;
$dd = $_POST['edno_tri_n_g'] ;
$gg = $_POST['ob6to_n_g'];
$date = $_POST['date'];
$izgotvil = $_POST['izgotvil'];
$join = date("d-m-Y");
if (strlen($date = trim($date)) == 0){
die('не е попълнено полето за Период');}

if (strlen($izgotvil = trim($izgotvil)) == 0){
die('не е попълнено полето за Изготвил');}


$sql = "INSERT INTO `parvi` (`id`,`date`,`izgotvil`,`edno_n_g`,`edno_edno_n_g`,`edno_dve_n_g`,`edno_tri_n_g`,`ob6to_n_g`)
VALUES (NULL, '', '$date', '$izgotvil', '$join', '', '', '','' ,'','$aa','$bb','$cc','$dd','$gg')";
$result = mysql_query($sql) or die(mysql_error()); 




if($result == true){
echo' сведение за <b>'.$date.' </b> г. е добавено упешно!' ;
echo' <a href="my.php?s=step2&c='.$date.'"> ---> Към стъпка 2 <--- </a>' ;
}
else {
echo' сведение за <b>'.$date.'</b> г. не може да бъде добавено!';
}
 

}else{

$vrazka = mysql_query("SELECT * FROM `parvi` WHERE vrazka='no'") or die('не може да изпълни заявката!');
$vrazka_r = mysql_fetch_array($vrazka);
$aa = $vrazka_r['edno_n_g']; 
$bb = $vrazka_r['edno_edno_n_g'];
$cc = $vrazka_r['edno_dve_n_g'] ;
$dd = $vrazka_r['edno_tri_n_g'] ;
$gg = $vrazka_r['ob6to_n_g'];
echo'

<table border="0" cellspacing="3" cellpadding="3" align="cetnter">
<tr><td><h2>С Ъ З Д А В А Н Е    НА    С  В  Е  Д  Е  Н  И  Е</h2></td></tr>
<tr><td>
<form method="post" action="">

<table border="0" cellspacing="3" cellpadding="3" id="table2">
<tr>
<td>Период:</td><td><input type"text" name="date"> </td> <td><font color=red>пример: 01.01-30.01.2010</font></td>
</tr>
<tr>
<td>Изготвил:</td><td> <input type"text" name="izgotvil"></td> <td> <font color=red>пример: Д.Иванова</font></td>
</tr>
<tr><td> </td>
<td align="center"><input name="submit" type="submit" id="button" value="Създай" /></td>
</tr>
</table>
</form>
</td>
</tr>



 
<tr><td>
<table border="0" cellspacing="0" cellpadding="0" id="table" align="center">
<tr><td>Последно записани на дата: '.$vrazka_r['join'].'</td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" id="table" align="center">


<tr><td>№</td><td>Размер</td><td>От началото на годината</td></tr> 
<tr>
<td>I</td>
<td>Коркови тапи - натурални:</td>

<td> </td>
</tr>
<tr>
<td>1</td>
<td>21х33мм Първо</td>
<td><input type"text" name="edno_n_g" readonly  VALUE="'.$aa.'"></td>
</tr>
<tr>
<td> </td>
<td>21х33мм	второ</td>

<td><input type"text" name="edno_edno_n_g" readonly  VALUE="'.$bb.'"></td>
</tr>
<tr>
<td> </td>
<td>21х33мм	трето</td>

<td><input type"text" name="edno_dve_n_g" readonly  VALUE="'.$cc.'"></td>
</tr>
<tr>
<td> </td>
<td>21х33мм	смес/колматирани</td>

<td><input type"text" name="edno_tri_n_g" readonly  VALUE="'.$dd.'"></td></td>
</tr>
<tr>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"><b>*Общо за 21х33мм</b></td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"><input type"text" name="ob6to_n_g" readonly  VALUE="'.$gg.'"></td>
</tr>

<td>2</td>
<td>23х33мм	първо</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>23х33мм	второ</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>23х33мм	трето/колматирани</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">*Общо за 23х33мм</td>

<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>

<td>3</td>
<td>24х38мм	супер</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>24х38мм	първо</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>24х38мм	смес</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>24х38мм	трето/колматирани</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">*Общо за 24х38мм</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>

<td>4</td>
<td>24х45мм	екстра</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>24х45мм	супер</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>24х45мм	първо</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>24х45мм	второ</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td>24х45мм	колматирани</td>

<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">*Общо за 24х45мм</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>



<tr>
<td>5</td>
<td>24х49мм екстра/супер</td>
<td> </td>
</tr>

<tr>
<td>6</td>
<td>29х27/19.5мм пласт.глава</td>
<td> </td>
</tr>


<tr>
<td> </td>
<td>конус</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">Общо:натурални</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>


<tr>
<td>II</td>
<td>Коркови тапи - агломерирани</td>
<td> </td>
</tr>


<tr>
<td>1</td>
<td>20.5х33мм/21,7/33мм</td>
<td> </td>
</tr>

<tr>
<td>2</td>
<td>23х33мм</td>
<td> </td>
</tr>

<tr>
<td>3</td>
<td>23х35;23.5х38мм</td>
<td> </td>
</tr>

<tr>
<td>4</td>
<td>23.5х44мм</td>
<td> </td>
</tr>

<tr>
<td>6</td>
<td>24х44мм</td>
<td> </td>
</tr>

<tr>
<td>7</td>
<td>23,5х39мм 1+1А</td>
<td> </td>
</tr>

<tr>
<td>8</td>
<td>23.5х44мм  1+1 А</td>
<td> </td>
</tr>

<tr>
<td>9</td>
<td>47x30,5мм</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">Общо агломерирани</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">Общо І + ІІ</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>


</table>

</td></tr>
</table>';

}
}?>




<? 


if($_GET['s']==step2){

function secure($var) {
return addslashes(htmlspecialchars($var));
}
$id = secure(@$_GET['c']); 
$step = mysql_query("SELECT * FROM `create` WHERE date='$id'") or die('не може да изпълни заявката');
$step_r = mysql_fetch_object($step);


echo'
<table border="0" cellspacing="3" cellpadding="3" align="cetnter">
<tr><td><h2>ВИНПРОМ СЕРВИЗ ПОРТУГАЛИЯ КОРК АД КЛОН НАДАРЕВО</h2></td></tr>';
echo' 
<tr><td><h2><br><br>С  В  Е  Д  Е  Н  И  Е</h2></td></tr>
<tr><td><h2><br><br>за продадените коркови тапи за периода '.$step_r->date.' г.</h2></td></tr>
<tr><td>

<table border="1" cellspacing="0" cellpadding="0" align="center" id="table">
<tr><td>№</td><td>Размер</td><td>'.$step_r->date.'</td><td>От началото на годината</td></tr> 

<tr>';
$parvi = mysql_query("SELECT * FROM `parvi` WHERE id='$id'") or die('не може да изпълни заявката');
$parvi_r = mysql_fetch_array($parvi);
$id = $parvi_r['id'];
$a = $parvi_r['1'];
$b = $parvi_r['1.1'];
$c = $parvi_r['1.2'];
$d = $parvi_r['1.3'];
$f = $a+$b+$c+$d;
mysql_query("UPDATE parvi SET ob6to_1 = '$f' WHERE id='$id'")or die(mysql_error()); 
$g = $parvi_r['ob6to_1'];

//----------------------------------------------------------------------------------------------
$aa = $parvi_r['1_1'] + $a;
$bb = $parvi_r['1_2'] + $b;
$cc = $parvi_r['1_3'] + $c;
$dd = $parvi_r['1_4'] + $d;
$ff = $aa+$bb+$cc+$dd;
mysql_query("UPDATE parvi SET ob6to_1_1 = '$ff' WHERE id='$id'")or die(mysql_error()); 
$gg = $parvi_r['ob6to_1_1'];
echo'
<td>I</td>
<td>Коркови тапи - натурални:</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>1</td>
<td>21х33мм Първо</td>
<td>'.$a.'</td>
<td>'.$aa.'</td>
</tr>
<tr>
<td> </td>
<td>21х33мм	второ</td>
<td>'.$b.'</td>
<td>'.$bb.'</td>
</tr>
<tr>
<td> </td>
<td>21х33мм	трето</td>
<td>'.$c.'</td>
<td>'.$cc.'</td>
</tr>
<tr>
<td> </td>
<td>21х33мм	смес/колматирани</td>
<td>'.$d.'</td>
<td>'.$dd.'</td>
</tr>
<tr>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"><b>*Общо за 21х33мм</b></td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">'.$g.'</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">'.$gg.'</td>
</tr>

<td>2</td>
<td>23х33мм	първо</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>23х33мм	второ</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>23х33мм	трето/колматирани</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">*Общо за 23х33мм</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>

<td>3</td>
<td>24х38мм	супер</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>24х38мм	първо</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>24х38мм	смес</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>24х38мм	трето/колматирани</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">*Общо за 24х38мм</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>

<td>4</td>
<td>24х45мм	екстра</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>24х45мм	супер</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>24х45мм	първо</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>24х45мм	второ</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>24х45мм	колматирани</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">*Общо за 24х45мм</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>



<tr>
<td>5</td>
<td>24х49мм екстра/супер</td>
<td> </td>
<td> </td>
</tr>

<tr>
<td>6</td>
<td>29х27/19.5мм пласт.глава</td>
<td> </td>
<td> </td>
</tr>


<tr>
<td> </td>
<td>конус</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">Общо:натурални</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>


<tr>
<td>II</td>
<td>Коркови тапи - агломерирани</td>
<td> </td>
<td> </td>
</tr>


<tr>
<td>1</td>
<td>20.5х33мм/21,7/33мм</td>
<td> </td>
<td> </td>
</tr>

<tr>
<td>2</td>
<td>23х33мм</td>
<td> </td>
<td> </td>
</tr>

<tr>
<td>3</td>
<td>23х35;23.5х38мм</td>
<td> </td>
<td> </td>
</tr>

<tr>
<td>4</td>
<td>23.5х44мм</td>
<td> </td>
<td> </td>
</tr>

<tr>
<td>6</td>
<td>24х44мм</td>
<td> </td>
<td> </td>
</tr>

<tr>
<td>7</td>
<td>23,5х39мм 1+1А</td>
<td> </td>
<td> </td>
</tr>

<tr>
<td>8</td>
<td>23.5х44мм  1+1 А</td>
<td> </td>
<td> </td>
</tr>

<tr>
<td>9</td>
<td>47x30,5мм</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">Общо агломерирани</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>
<tr>
<td> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;">Общо І + ІІ</td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
<td style="border-top:2px solid #000;border-bottom:2px solid #000;"> </td>
</tr>
</table>
</td></tr>
<tr><td align="right" style="padding: 14 200; font-size: 20;">Изготвил:<br><em>/'.$create_r->izgotvil.'/</em>
</td></tr>
</table>';
 
Код: 
$sql = "INSERT INTO `parvi` (`date`,`izgotvil`,`edno_n_g`,`edno_edno_n_g`,`edno_dve_n_g`,`edno_tri_n_g`,`ob6to_n_g`) 
VALUES ('$date', '$izgotvil','$aa','$bb','$cc','$dd','$gg')"; 
$result = mysql_query($sql) or die(mysql_error());

:)
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе