error in sql query.

---

SELECT media_id, sort_order, file_name, actual_file_name, alt_tag_data, external_link, room_name, caption, content_type FROM media WHERE property_id = AND record_type = 'picture' AND lang = 'eng'

---

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 'AND record_type = 'picture' AND lang = 'eng'' at line 2error in sql query.

---

(SELECT media_id, sort_order, file_name, actual_file_name, alt_tag_data, external_link, room_name, caption, content_type FROM media WHERE property_id = AND record_type = 'picture' AND lang = 'eng' ) UNION (SELECT media_id, sort_order, file_name, actual_file_name, alt_tag_data, external_link, room_name, caption, content_type FROM media WHERE property_id = AND record_type = 'relatedPicture' AND lang = 'eng' ) ORDER BY sort_order

---

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 'AND record_type = 'picture' AND lang = 'eng' ' at line 2error in sql query.

---

SELECT media_id, sort_order, file_name, actual_file_name, alt_tag_data, external_link, room_name, caption, content_type FROM media WHERE property_id = AND record_type = 'attachment' AND lang = 'eng'

---

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 'AND record_type = 'attachment' AND lang = 'eng'' at line 2error in sql query.

---

SELECT media_id, sort_order, file_name, actual_file_name, alt_tag_data, external_link, room_name, caption, content_type FROM media WHERE property_id = AND record_type = 'attachment' AND lang = 'eng'

---

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 'AND record_type = 'attachment' AND lang = 'eng'' at line 2

Back to List

Property Type /