does not work with multiple Ceck Box

Using the wizard to the search page does not work when I use more than one ceck box. Why?

try adding the following code at line 1 of the results page:

<?php

if($_SERVER["REQUEST_METHOD"] == "POST")     {

    foreach($_POST as $key => $val) {

        if(is_array($_POST[$key])) $_POST[$key] = implode(", ", $_POST[$key]);

    }

}

?>

if you continue to have a problem, please post a link where I can test this, and compress the search and results page to a zip archive and attach the zip file to your reply.

Still does not work. Please solve the problem quickly. Also because the software is not free but a fee. I do not want to be a tester but the user of a software that works!

I think the issue is in the way you have set the DataAssist search up to use the checkboxes.

when you select to Use Checkbox search criteria type, you will need to specify the Checked and Unchecked values to use.

With the other search criteria types, they will not be included if there is no value, but with the checkbox search criteria type, they will be included and use the unchecked value you set.

see the attached screen shot for more details

Most likely, for your needs, you would want to use the edit criteria type, even for the check boxes.

I have already done so. but after doing this does not work.

OK, please send the most recent copy of your page, and a link where i can test this in the browser.

Referring to your request this is the page.
The page's link is:
soci_Search.php

Add this to the page:

<?php echo($query_WADAsoci); ?>

That will allow you to view the query created by the search page and might allow you (or me) to figure out why it isn't working right.

Does the database use '1' and '0' for the column values for those fields? It looks like the search is using 1 and 0 to filter.

SELECT idsocio, tessera, cognome, nome, indirizzo, cap, citta, pr, telefono, cellulare, email, Sballo, Sbiliardo, Sburscabrid, Scarte, Sciclismo, Scultura, Sfoto, Smontagna, Smusica, Spittura, Sturismo, Svela, Saltro FROM soci WHERE (Sballo = 1) AND (Sbiliardo = 0) AND (Sburscabrid = 0) AND (Scarte = 0) AND (Sciclismo = 0) AND (Scultura = 0) AND (Sfoto = 0) AND (Smontagna = 0) AND (Smusica = 0) AND (Spittura = 0) AND (Sturismo = 0) AND (Svela = 0) AND (Saltro = 0) ORDER BY cognome ASC

Like i said in my initial reply, I think you may want to use the edit criteria type for the checkboxes instead of the checkbox criteria type.


the difference between them is that with an edit criteria type, the column will not be included in the search if the box is not checked.

with checkbox criteria type, that column will still be included in the search, just using the unchecked value "0"