Zymic Webmaster Forums > Sql Error [ Mysql4 ]

Zymic Webmaster Forums > Web Design & Development > Server Side Scripting > PHP

MrTouz

Oct 24 2007, 02:08 PM

QUOTE

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 ''%Choisir Aller%' AND eurostarretour LIKE '%Choisir Retour%' AND lieupublic LIKE' at line 1 [1064]

this is what i have been dealing with for the past week :/

does anyone knows what can be the error for this ? it says Syntax... but what is it ? did i typed something incorrectly ? or did i have to declare something that i forgot ? i really donno what it is and its driving me crazy not to know :'(

ive been trying to find.. edit some stuff. delet some others.. add some stuff.. but damn, i can't find anythoing aobut this.

any help will be much apreciated !

Alex

Oct 24 2007, 02:13 PM

What is the full query?

MrTouz

Oct 24 2007, 02:31 PM

sorry for being noobish and wasting your time :/

i found the stupidest error in the world i forgot a LIKE between aller and retour :

CODE

$eurostaraller = request_var('eurostaraller', '');
if($eurostaraller != "ALL")
$sql .= " AND eurostaraller [b]LIKE[/b] '%".$eurostaraller."%'";

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.