Jump to content

Error in MySQL Syntax


vicdesigns

Recommended Posts

Howdy folks,

 

I am creating a Facebook app for a bit of fun and practice and getting the following error in index.php:

 

Invalid query -- SELECT * FROM `results` WHERE `resultLow` <= AND `resultHigh`>= -- 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 `resultHigh`>=' at line 1

 

Here is the area:

 

$res = query("SELECT * FROM `results` WHERE `resultLow` <=$user_score AND `resultHigh`>=$user_score");

 

Any help would be appreciated.

Link to comment
https://forums.phpfreaks.com/topic/234820-error-in-mysql-syntax/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.