mysql_query AND OR

[violinrocker]

what is wrong with this? it says i do not have the right syntax.... im assuming that i cannot use AND & OR together?

 

$q = "SELECT * FROM  here WHERE page_id='$_GET[id]' OR parent='$_GET[id]' AND default='0' ORDER by page_id DESC LIMIT 1";

 

okay so i tried changing "default='0'" to "mirror='0'" and it works.... im sure "default" is in my table though

[PFMaBiSmAd]

There's nothing technically wrong with what you posted.

 

Best guess is there is something in the actual $_GET['id'] that is the problem.

 

Posting the actual error message would help pin down what the problem is.

[DavidAM]

Isn't default a reserved word? If you are using it as a column name, you have to put back-ticks around it.

 

... AND `default` = '1' ... 

[Maq]

Isn't default a reserved word? If you are using it as a column name, you have to put back-ticks around it.

 

... AND `default` = '1' ... 

Yes it is.  OP, you should avoid using reserved words as table names.  Here is a list:

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

[sasa]

and

AND is evaluate before OR