I'm having this weird issue (Rope is currently around my neck ). Im using query below via PHP to display rows from a MYSQL database. The "private !- 1" part is not working, hence its still displaying the rows where "private is equal to 1".
The strange thing is, that the "private !- 1" works fine when I remove this part "AND title LIKE '%$getSearch%' OR name LIKE '%$getSearch%' OR lang LIKE '%$getSearch%' OR raw LIKE '%$getSearch%'"
Query not Working:
PHP Code:
mysql_query("SELECT * FROM players WHERE private != 1 AND title LIKE '%$getSearch%' OR name LIKE '%$getSearch%' OR lang LIKE '%$getSearch%' OR paw LIKE '%$getSearch%' ");
Working Query:
PHP Code:
mysql_query("SELECT * FROM players WHERE private != 1 ");
Can anyone see anything that I may be missing ?