CODEWITHSUNDEEP
mysqlkeyword
Ben
Ben

Reputation: 62364

MySQL Reserved Keyword

I'm having an issue with this query...

SELECT account_id FROM `clock`
 WHERE account_id = '.$accountId.' AND `clock`.`in` > 0 AND `clock`.`out` == 0

The only thing I can think of is that in/out are keywords.... but with backticks it should work fine.... right?

Upvotes: 0

Views: 304

Answers (1)

Evernoob
Evernoob

Reputation: 5561

You have a double equals there mate '=='

change it to a single '='.

Upvotes: 3

Related Questions