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 '' at line 1

[rootKID]

this is my code:

$menu_res = sql_query("SELECT * FROM menu WHERE menu_accessible = '".sqlesc("yes")."' AND menu_u_class_read_min <= ".$CURUSER['u_FK_uc_id']); // BETA

and 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 '' at line 1

 

Any help Oo?... tried with and without '' and sql-escape, with and without.. same error i get... ideas Oo?..

 

Thanks if possible!

[Ingolme]

Print out the value of the string you're using as an SQL query to see what it says.

echo "SELECT * FROM menu WHERE menu_accessible = '".sqlesc("yes")."' AND menu_u_class_read_min <= ".$CURUSER['u_FK_uc_id'];exit; // End program so we can read what was printed

[rootKID]

ok... found the error.. i seriously need to get my eyes fixed x)...