sql where issue
Posted on 2011-09-09
See my below code:
WHERE td.call_back_id = ".$row_rs_call_back_request['id']." AND td.hide_comment IS NULL OR td.hide_comment = 'No'";
I must be writing it incorrectly as I am not getting the correct result.
I basically want the code after the AND grouped.
td.call_back_id = ".$row_rs_call_back_request['id']."
(td.hide_comment IS NULL OR = 'No')
I have just put bracket to separate and try to explain what I require, but not sure how to write.
How it makes sense. Ask if not?