I followed what you said but something is still causing for it not to work:
Quote:
|
SELECT count(*) AS totalrows FROM bible WHERE 1=1 AND CASE WHEN text_data LIKE '%offering%' THEN 1 ELSE 0 END + CASE WHEN text_data LIKE '%tabernacle%' THEN 1 ELSE 0 END + CASE WHEN text_data LIKE '%congregation%' THEN 1 ELSE 0 END + CASE WHEN text_data LIKE '%Aaron%' THEN 1 ELSE 0 END > 3
|
I removed the
limit
I put:
PHP Code:
echo $row['totalrows']."<br />";
which gives blank.
And the result doesn't show. When I remove the count(*) AS totalrows then I get the result again.