Fatal error: Cannot redeclare class WA_MySQLi_RS in ...

I have built a search results page that also contains refine filtering using AJAX which loads the refined results into a div (Load Plugin to div via framework builder) on the same page. The problem is, i need a MySQLi recordset on the results page (to populate the filters) as well as the refined results framework plugin (to return the refined search results), however i am getting this error because the rsobj.php include is on both pages. This is required by MySQLi to generate the recordsets.

Is there a workaround so I only have to include rsobj.php on one of the pages to avoid the error (Fatal error: Cannot redeclare class WA_MySQLi_RS in ...)?

Make sure the file is included with require_once() so that it won't be repeated.

That;s the way I have it setup but it is required on the plugin page as well, otherwise the recordset does not work..This is the error I get if I only require_once() on the results page:

Fatal error: Class 'WA_MySQLi_RS' not found in /home/......./public_html/search_results.php on line 47

Line 47 is the first line of the recordset.

Can I get FTP access to the site and a url to reproduce the problem? I would think it would work if you have require_once in both files, but I'll test to try to determine what the issue is.

PM

OK I have fixed the errors (I regularly seem to get things working shortly after posting to the support forums), just need to get the filtering to add to the results each time more checkboxes are ticked. For example, if I am filtering by postcode and the postcode checkboxes are populated by a MySQLi recordset, I have 1 binding set to filter the postcodes but if more than 1 checkboxes are ticked, it should add to the results. Can you please advise how this can be achieved?

I understand that if I have different filters in place, eg. by postcode, by price, by star rating etc... then I would just add the additional bindings and add to the SQL query but how do you achieve with 1 binding on dynamically generated checkboxes?

There is an option in the MySQLi recordset parameter that will allow you to pass parameters as "comma separated list". This will allow you to use an IN statement in your query to allow multiple selections like:

SELECT * FROM Table WHERE postalCode IN (param)

then param can be set to allow comma separated lists and then you name all your checkboxes with the same name (with brackets so they are passed as an array) like: name="postalCheck[]"

Then set the parameter value to create a comma separated list from the array like: <?php echo(implode(",",$_POST['postalCheck'])); ?>

Man you are GOOOOOOD!

One problem, if all the suburb checkboxes are deselected I get this error:

Notice: Undefined index: suburb in /home/....../public_html/filtered_results.php on line 12

Warning: implode() [function.implode]: Invalid arguments passed in /home/........../public_html/filtered_results.php on line 12

Please attach a copy of the page and I'll take a look.