|
|
|
|
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 'condition=796 AND control=812
AND mileage=56 AND title LIKE "%text%" OR
descript' at line 1
SELECT * from Cars WHERE kpp=802 AND
engine=808 AND condition=796 AND control=812
AND mileage=56 AND title LIKE "%text%" OR description
LIKE "%text%" OR content LIKE "%text%" OR price
LIKE "%text%" AND price>=1 AND price<=2 AND
photo!= "" AND hot=1 AND exchange=1
|
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 'condition=796 AND kpp=802 AND control=812 AND photo!= ""' at line 1
SELECT * from Cars WHERE
marka=916 AND condition=796
AND kpp=802 AND control=812 AND photo!= ""
|
Не вижу проблемы | |
|
|
|
|
|
|
|
для: OLi
(26.10.2012 в 02:02)
| | ковычки не пробывал одинарные!?
SELECT * from Cars WHERE kpp=802 AND
engine=808 AND condition=796 AND control=812
AND mileage=56 AND title LIKE '%text%' OR description
LIKE '%text%' OR content LIKE '%text%' OR price
LIKE '%text%' AND price>=1 AND price<=2 AND
photo!= '' AND hot=1 AND exchange=1
|
| |
|
|
|
|
|
|
|
для: OLi
(26.10.2012 в 02:02)
| | condition -это ключевое слово!
Использовать его как имя поля - все равно что обозвать поле 'AND' и 'OR', а потом удивляться, почему запрос
SELECT * FROM tbl WHERE AND > 0 OR OR < 0
| вызывает ошибку.
Но если уж приспичило, то запрос можно исправить так:
SELECT * FROM tbl WHERE `AND` > 0 OR `OR` < 0
|
| |
|
|
|