The SQL statement in mysql_query () does not seem to contain parentheses.

The SQL statement in mysql_query () does not seem to contain parentheses. $ Rs = & nbsp; mysql_query ("select & nbsp; * & nbsp; from & nbsp; cxjb2 & nbsp; where & nbsp; nam & nbsp ;". the SQL statement in $ _ POST [se mysql_query () does not seem to contain parentheses.
$ Rs = mysql_query ("select * from cxjb2 where nam ". $ _ POST [select3]. "$ _ POST [nam] and cat ". $ _ POST [select0]. "$ _ POST [cat] and sha ". $ _ POST [select1]. "$ _ POST [sha] and pri is NULL or nam ". $ _ POST [select3]. "$ _ POST [nam] and cat ". $ _ POST [select0]. "$ _ POST [cat] and sha ". $ _ POST [select1]. "$ _ POST [sha]");

The preceding statement can be executed.

$ Rs = mysql_query ("(select * from cxjb2 where nam ". $ _ POST [select3]. "$ _ POST [nam] and cat ". $ _ POST [select0]. "$ _ POST [cat] and sha ". $ _ POST [select1]. "$ _ POST [sha]) and (pri is NULL or pri is not null )");

When the same logical relationship is converted to this statement, it cannot be successfully executed.

Please kindly advise




Share SQL:
------ Solution --------------------
All SQL commands must begin with SQL commands.