phpTippse
24.07.2007, 15:27:07
Hi Leute,
warum funktioniert meine folgende Abfrage von PHP aus auf meine MySQL Datenbank nicht?
SELECT uid FROM user WHERE sex = w AND (alter BETWEEN '20' AND '21' AND show_alter = 1) AND (image IS NOT NULL) AND active = 1 LIMIT 15
Ich bekomme folgende Fehlermeldung:
Error: Exception: MySQL-Error: 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 'alter BETWEEN '20' AND '21' AND show_alter = 1)
AND (image IS NOT NULL)
' at line 3 in Query: SELECT uid FROM user
WHERE sex = w
AND (alter BETWEEN '20' AND '21' AND show_alter = 1)
AND (image IS NOT NULL)
AND active = 1
LIMIT 15
Liegt es an dem Blobfeld, dass man den Inhalt anders abfragen muss? Oder muss irgendwo Kommata setzen?
warum funktioniert meine folgende Abfrage von PHP aus auf meine MySQL Datenbank nicht?
SELECT uid FROM user WHERE sex = w AND (alter BETWEEN '20' AND '21' AND show_alter = 1) AND (image IS NOT NULL) AND active = 1 LIMIT 15
Ich bekomme folgende Fehlermeldung:
Error: Exception: MySQL-Error: 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 'alter BETWEEN '20' AND '21' AND show_alter = 1)
AND (image IS NOT NULL)
' at line 3 in Query: SELECT uid FROM user
WHERE sex = w
AND (alter BETWEEN '20' AND '21' AND show_alter = 1)
AND (image IS NOT NULL)
AND active = 1
LIMIT 15
Liegt es an dem Blobfeld, dass man den Inhalt anders abfragen muss? Oder muss irgendwo Kommata setzen?