значит есть файл edit_reklama вот код: PHP: <?php $rek_id = $_POST['rek_id']; $pid = $_POST['pid']; $oper_type = $_POST['oper_type']; $rek_name = $_POST['rek_name']; $rek_banner = basename($_FILES['rek_banner']['name']); $rek_www = $_POST['rek_www']; $sorted = $_POST['priority']; $rubr_id = $_POST['rubr_id']; include("setting.php"); $db=connect_db(); $db_name=db_name(); mysql_select_db($db_name,$db); mysql_query("SET NAMES CP1251"); //--------------Добавление-------------------------------------------- if ($oper_type == 'I'){ $sql = "insert into reklama (rek_name, rek_www,sorted,rubr_id)"; $sql = $sql." select '$rek_name','$rek_www',$sorted, $rubr_id"; $result=mysql_query($sql,$db); print "$sql<br>"; if (!$result) {print "<br>$sql"; mysql_close($db); exit();} else{ $rek_id = mysql_insert_id(); } }// if 'I' elseif ($oper_type == 'E'){ //print "edit<br>"; $sql = "update reklama set rek_name = '$rek_name', rek_www = '$rek_www', `sorted` = $sorted, rubr_id = $rubr_id, where rek_id = $rek_id "; $result=mysql_query($sql,$db); if (!$result) {print "<br>$sql"; mysql_close($db); exit();}; } $uploaddir = "../images/reklama/".$rek_id; if (!is_dir($uploaddir)){ mkdir($uploaddir,0755); }// if is_dir if ($rek_logo != ''){ $uploadfile = $uploaddir."/".$rek_logo; move_uploaded_file($_FILES['rek_banner']['tmp_name'], $uploadfile); chmod($uploadfile, 0755); $sql = "update reklama set rek_banner='$rek_banner' where rek_id = $rek_id"; $result=mysql_query($sql,$db); if (!$result) {print "<br>$sql"; mysql_close($db); exit();} } /* Закрываем соединение */ mysql_close($db); echo "<head><meta http-equiv=\"Refresh\" content=\"1; url=index.php?pid=$pid\"></head>"; ?> при сохранении пишет такую фигню: insert into reklama (rek_name, rek_www,sorted,rubr_id) select 'werrrrrr','http://fenix-moscow.ru/',0, 185 insert into reklama (rek_name, rek_www,sorted,rubr_id) select 'werrrrrr','http://fenix-moscow.ru/',0, 185 делаю sql запрос? выдает: #1064 - 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 reklama (rek_name, rek_www,sorted,rubr_id) select 'werrrrrr','http:/' at line 3 когда делаю такой запрос: insert into reklama (rek_name, rek_www,sorted,rubr_id) select 'werrrrrr','http://fenix-moscow.ru/',0, 185 выдает: #1364 - Field 'rek_id' doesn't have a default value что за фигня?????