Search Reloaded does not respect “cat” searches

I’m almost there on this one; I do:

$category_branch = “”;
$cat = get_query_var(‘cat’);
if (isset($cat) && !empty($cat)) {
// $category_branch = ” AND posts.ID = ANY (SELECT post_id FROM $wpdb->post2cat WHERE category_id=” . $cat . “) “;
}

and then just append $category_branch into the query.

However, I can’t get it working. What am I doing wrong?

AHA. My host is using mysql 4, which doesn’t support subqueries. Here is the fix for the search_reloaded plugin:

Just before $search_query is defined, add the following:

$where = ” WHERE “;
$cat = get_query_var(‘cat’);
if (isset($cat) && !empty($cat)) {
$where = “, $wpdb->post2cat AS cat WHERE cat.category_id = ” . $cat . ” AND cat.post_id = posts.ID AND “;
}

Now, replace the line a little further down:

WHERE

with:

” . $where . “

This will only search one category. WordPress’ internal search has teh ability to search multiple, but I don’t need that, so …