FindMe
Новичок
Товарищи, помогите, пожалуйста! Как правильно писать такие запросы на php?
Запрос на MySQL: Insert into a(n, id_st, id_d) VALUES ('С', 'Со', (SELECT id_d FROM b)).
Вот мой запрос на php.
$query = "INSERT INTO object (id_object, name_of_the_object, adress, id_settlement, name_of_the_settlement, ".rn"id_district, name_of_the_district, remoteness_from_SPb, id_roadway, name_of_the_roadway, ".rn"area, number_of_hectare, buildings, id_kind_of_the_com, kind_of_the_com, id_kind_of_the_ownership, kind_of_the_ownership, ".rn"first_price, finish_price, photo, comments_for_the_object, comments_for_com) VALUES ('$id_object', '$name_of_the_object', ".rn"'$adress',(SELECT '$id_settlement' FROM settlement),(SELECT '$name_of_the_settlement' FROM settlement), ".rn"(SELECT '$id_district' FROM district),(SELECT '$name_of_the_district' FROM district), '$remoteness_from_SPb', ".rn"(SELECT '$id_roadway' FROM direction),(SELECT '$name_of_the_roadway' FROM direction), '$area', '$number_of_hectare', '$buildings', ".rn"(SELECT '$id_kind_of_the_com' FROM communications),(SELECT '$kind_of_the_com' FROM communications), ".rn"(SELECT '$id_kind_of_the_ownership' FROM ownership),(SELECT '$kind_of_the_ownership' FROM ownership), ".rn"'$first_price', '$finish_price', '$photo', '$comments_for_the_object', (SELECT '$comments_for_com' FROM com_of_the_object)";
Выдает ошибку:
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.
Запрос на MySQL: Insert into a(n, id_st, id_d) VALUES ('С', 'Со', (SELECT id_d FROM b)).
Вот мой запрос на php.
$query = "INSERT INTO object (id_object, name_of_the_object, adress, id_settlement, name_of_the_settlement, ".rn"id_district, name_of_the_district, remoteness_from_SPb, id_roadway, name_of_the_roadway, ".rn"area, number_of_hectare, buildings, id_kind_of_the_com, kind_of_the_com, id_kind_of_the_ownership, kind_of_the_ownership, ".rn"first_price, finish_price, photo, comments_for_the_object, comments_for_com) VALUES ('$id_object', '$name_of_the_object', ".rn"'$adress',(SELECT '$id_settlement' FROM settlement),(SELECT '$name_of_the_settlement' FROM settlement), ".rn"(SELECT '$id_district' FROM district),(SELECT '$name_of_the_district' FROM district), '$remoteness_from_SPb', ".rn"(SELECT '$id_roadway' FROM direction),(SELECT '$name_of_the_roadway' FROM direction), '$area', '$number_of_hectare', '$buildings', ".rn"(SELECT '$id_kind_of_the_com' FROM communications),(SELECT '$kind_of_the_com' FROM communications), ".rn"(SELECT '$id_kind_of_the_ownership' FROM ownership),(SELECT '$kind_of_the_ownership' FROM ownership), ".rn"'$first_price', '$finish_price', '$photo', '$comments_for_the_object', (SELECT '$comments_for_com' FROM com_of_the_object)";
Выдает ошибку:
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.
