dubasua пишет:Покажите ошибку.
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Не стал писать весь код, а только общий запрос, т.е. на примере хотя бы одного запроса.
А так вот сам код:
$query = "INSERT INTO object (id_object, name_of_the_object, adress, id_settlement, name_of_the_settlement, ".
"id_district, name_of_the_district, remoteness_from_SPb, id_roadway, name_of_the_roadway, ".
"area, number_of_hectare, buildings, id_kind_of_the_com, kind_of_the_com, id_kind_of_the_ownership, kind_of_the_ownership, ".
"first_price, finish_price, photo, comments_for_the_object, comments_for_com) VALUES ('$id_object', '$name_of_the_object', ".
"'$adress',(SELECT '$id_settlement' FROM settlement),(SELECT '$name_of_the_settlement' FROM settlement), ".
"(SELECT '$id_district' FROM district),(SELECT '$name_of_the_district' FROM district), '$remoteness_from_SPb', ".
"(SELECT '$id_roadway' FROM direction),(SELECT '$name_of_the_roadway' FROM direction), '$area', '$number_of_hectare', '$buildings', ".
"(SELECT '$id_kind_of_the_com' FROM communications),(SELECT '$kind_of_the_com' FROM communications), ".
"(SELECT '$id_kind_of_the_ownership' FROM ownership),(SELECT '$kind_of_the_ownership' FROM ownership), ".
"'$first_price', '$finish_price', '$photo', '$comments_for_the_object', (SELECT '$comments_for_com' FROM com_of_the_object)";
(Добавление)
AmsTaFF пишет:
и текст ошибки не помешал бы )
Выбрать значения $id_d из таблицы b.(Отредактировано автором: 16 Июня, 2013 - 21:08:05)
|