Question: FULLTEXT Search with &&

programming
1

hello,

i have this:


$query = "SELECT * FROM news_table"
        	. " WHERE MATCH(title,content) AGAINST('".$keywords."' IN "
        	. " BOOLEAN MODE) LIMIT ".$qty;

this will display all results regardless of STATUS (inactive/active)

BUT, i also want this to work:


$status = "active";
$query = "SELECT * FROM news_table"
        	. " WHERE status = ".$status." && MATCH(title,content) AGAINST('".$keywords."' IN "
        	. " BOOLEAN MODE) LIMIT ".$qty;

in short, i want to get the all results whose STATUS is, let’s say ACTIVE…
how would i do that???
the second code, does not seem to work for me. it wont not display the result i want…

any help would be greatly appreciated… thanks guys… :smiley: