Coding a report using checkboxes

Anon

Can you use checkboxes on a form to select which criteria you would like to see in a mysql query.

I can write the form putting in the checkboxes using an array, but im stumped on how to exactly write the query so it only pulls out the information i selected using the checkboxes

Any help is appreciated, thanks

Anon

Depends on how you set it up. If your checkboxes are related to various fields then just walk through them and build your select string:

$select = "SELECT ";
for (reset($fields); $key = key($fields); next($fields)) {
$select .= $fields[$key] . ",";
}

$select = substr($select, 0, (strlen($select) -1));

$query = $select . " From table";

Anon

Which would you like to see on this report
<FORM method=post action=dothis.php>
<INPUT TYPE=checkbox NAME=INCLUDE_ARRAY[] value=first_name> First Name<br>

<INPUT TYPE=checkbox NAME=INCLUDE_ARRAY[] value=email_address> Email Address<br>

7 more checkboxes like above

</FORM>

So i only want to see Last Name and email address, so i check last name and email address and leave first name checkbox unchecked. Hit submit, How does the query get coded to only find last name and email address?

Anon

I got it figured, thanks for the help