Простой запрос с кучей переменных:
$query_ob = mysql_query('insert into zakaz_ob (insert into zakaz_ob (Nzak,Nzap,Datesogl,Enn,Nameprod,Kontragent,Kodzak,Zakazchik,Subzak,Osnovanie,Ceh,Edizm,Rdate,Rkol,Vidprod,Ndoc,Gost,Datadoc,Kolvo,Price,Sum,Vdate,Vkol,Ves1,Ves,Trud1,Trud,Vlkcp,Vlkcf,Vsspp,Vsspf,Vmopp,Vmopf,Vopc1p,Vopc1f,Vopc2p,Vopc2f,Vopc3p,Vopc3f,Plandate,Kolzayv,Sogldate,Soglkol,Nasogl,Rabceh,Datezap,Otkkol,Otkdate,Dozip,Dteh,Domts,Dorp,Dpeo,Dpr,Sspkol,Lkckol,Mopkol,Opc1kol,Opc2kol,Opc3kol,Sspdate,Lkcdate,Mopdate,Opc1date,Opc2date,Opc3date) values ($Nzak,"$Nzap",$Datesogl,"$Enn","$Nameprod","$Kontragent","$Kodzak","$Zakazchik","$Subzak","$Osnovanie","$Ceh","$Edizm","$Rdate","$Rkol","$Vidprod","$Ndoc","$Gost",$Datadoc,$Kolvo,$Price,$Sum,"$Vdate","$Vkol",$Ves1,$Ves,$Trud1,$Trud,"$Vlkcp","$Vlkcf","$Vsspp","$Vsspf","$Vmopp","$Vmopf","$Vopc1p","$Vopc1f","$Vopc2p","$Vopc2f","$Vopc3p","$Vopc3f",$Plandate,$Kolzayv,$Sogldate,$Soglkol,"$Nasogl","$Rabceh",$Datezap,$Otkkol,$Otkdate,$Dozip,$Dteh,$Domts,$Dorp,$Dpeo,$Dpr,$Sspkol,$Lkckol,$Mopkol,$Opc1kol,$Opc2kol,$Opc3kol,$Sspdate,$Lkcdate, $Mopdate,$Opc1date,$Opc2date,$Opc3date)') or die('Could not connect: ' . mysql_error()); На выхлопе получаю:
Could not connect: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into zakaz_ob (Nzak,Nzap,Datesogl,Enn,Nameprod,Kontragent,Kodzak,Zakazchi' at line 1
Все переменные существуют, пробовал заменять " на \" все равно та же ошибка. describe zakaz_ob:
+-------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+----------------+
| id_zakaz_ob | int(11) | NO | PRI | NULL | auto_increment |
| Nzap | tinytext | YES | | NULL | |
| Datesogl | date | YES | | NULL | |
| Enn | tinytext | YES | | NULL | |
| Nameprod | text | YES | | NULL | |
| Kontragent | text | YES | | NULL | |
| Kodzak | int(11) | YES | | NULL | |
| Zakazchik | text | YES | | NULL | |
| Subzak | text | YES | | NULL | |
| Osnovanie | text | YES | | NULL | |
| Ceh | text | YES | | NULL | |
| Edizm | tinytext | YES | | NULL | |
| Rdate | tinytext | YES | | NULL | |
| Rkol | tinytext | YES | | NULL | |
| Vidprod | text | YES | | NULL | |
| Ndoc | tinytext | YES | | NULL | |
| Gost | tinytext | YES | | NULL | |
| Datadoc | date | YES | | NULL | |
| Kolvo | float | YES | | NULL | |
| Price | float | YES | | NULL | |
| Sum | float | YES | | NULL | |
| Vdate | tinytext | YES | | NULL | |
| Vkol | tinytext | YES | | NULL | |
| Ves1 | float | YES | | NULL | |
| Ves | float | YES | | NULL | |
| Trud1 | float | YES | | NULL | |
| Trud | float | YES | | NULL | |
| Vlkcp | tinytext | YES | | NULL | |
| Vlkcf | tinytext | YES | | NULL | |
| Vsspp | tinytext | YES | | NULL | |
| Vmopf | tinytext | YES | | NULL | |
| Vopc1p | tinytext | YES | | NULL | |
| Vopc1f | tinytext | YES | | NULL | |
| Vopc2p | tinytext | YES | | NULL | |
| Vopc2f | tinytext | YES | | NULL | |
| Vopc3p | tinytext | YES | | NULL | |
| Vopc3f | tinytext | YES | | NULL | |
| Plandate | date | YES | | NULL | |
| Kolzayv | float | YES | | NULL | |
| Sogldate | date | YES | | NULL | |
| Soglkol | float | YES | | NULL | |
| Nasogl | tinytext | YES | | NULL | |
| Rabceh | tinytext | YES | | NULL | |
| Datezap | date | YES | | NULL | |
| Otkkol | tinytext | YES | | NULL | |
| Otkdate | tinytext | YES | | NULL | |
| Dozip | date | YES | | NULL | |
| Dteh | date | YES | | NULL | |
| Domts | date | YES | | NULL | |
| Dorp | date | YES | | NULL | |
| Dpeo | date | YES | | NULL | |
| Dpr | date | YES | | NULL | |
| Sspkol | float | YES | | NULL | |
| Lkckol | float | YES | | NULL | |
| Mopkol | float | YES | | NULL | |
| Opc1kol | float | YES | | NULL | |
| Opc2kol | float | YES | | NULL | |
| Opc3kol | float | YES | | NULL | |
| Sspdate | date | YES | | NULL | |
| Lkcdate | date | YES | | NULL | |
| Mopdate | date | YES | | NULL | |
| Opc1date | date | YES | | NULL | |
| Opc2date | date | YES | | NULL | |
| Opc3date | date | YES | | NULL | |
| Nzak | int(11) | YES | | NULL | |
| Vspf | tinytext | YES | | NULL | |
| Vmopp | tinytext | NO | | NULL | |
+-------------+----------+------+-----+---------+----------------+
Не пойму что ему не нравится :-(
