violinrocker Posted March 25, 2011 Share Posted March 25, 2011 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 Quote Link to comment https://forums.phpfreaks.com/topic/231699-mysql_query-and-or/ Share on other sites More sharing options...
PFMaBiSmAd Posted March 25, 2011 Share Posted March 25, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/231699-mysql_query-and-or/#findComment-1192200 Share on other sites More sharing options...
DavidAM Posted March 25, 2011 Share Posted March 25, 2011 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' ... Quote Link to comment https://forums.phpfreaks.com/topic/231699-mysql_query-and-or/#findComment-1192224 Share on other sites More sharing options...
Maq Posted March 25, 2011 Share Posted March 25, 2011 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 Quote Link to comment https://forums.phpfreaks.com/topic/231699-mysql_query-and-or/#findComment-1192246 Share on other sites More sharing options...
sasa Posted March 25, 2011 Share Posted March 25, 2011 and AND is evaluate before OR Quote Link to comment https://forums.phpfreaks.com/topic/231699-mysql_query-and-or/#findComment-1192248 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.