Unchecked "no" value

[ThomaSServo]

I have a written some code that searches through a database. It's results are based on a series of checkboxes. Yes/No kind of stuff.

I have realized that I do not want the unchecked position to represent a "no" answer. Instead I want it to ignore that value in the search of the database.

I currently have a really basic

mysql_query("SELECT * FROM secondary_tbl WHERE program='$program1' AND program2='$program2'"

any suggestions (or links to a thread on this topic) on how to code it so that an unchecked box ignores that particular field instead of registering an automatic "no"

[devinemke]

unchecked boxes will not be returned in the $_POST array thus you can easily ignore them. a simple example:

<form action="" method="post">
checkbox #1 <input type="checkbox" name="boxes[]" value="1"><br>
checkbox #2 <input type="checkbox" name="boxes[]" value="2"><br>
checkbox #3 <input type="checkbox" name="boxes[]" value="3"><br>
<input type="submit" name="submit" value="submit">
</form>

<?php
if (isset($_POST['submit']))
{
	if (isset($_POST['boxes']))
	{
		echo 'you checked: ' . implode(', ', $_POST['boxes']);
	}
	else
	{
		echo 'you did not check any boxes';
	}
}
?>

[ThomaSServo]

Thank you for your reply!

It does indeed not return a value.
I guess I still don't know how to get the query to ignore that field when it is unchecked. Not inserting a value in the respective fields, the query does not return any results.

[devinemke]

dynamically build your query by looping thru the elements returned from your form