help with php script

[smartie91]

please help

what i need to do is to have a list of 8 checkbuttons with a maxinum of 3 buttons being checked when

you click a combinations of 3 buttons i wont then to connect to my Sql database and produce a query

of the 3 and display in a html page.

i hope i have made this clear and thanks for your help

smartie91

[ripken204]

can you at least make some code for the checkboxes so that we can see what you are talking about?

[smartie91]

sorry for the deley in getting back

this is basically what i need but instead of going to a webpage i need to query a database if you click on tennis and

football and boxing to find all collages that does tennis and football and boxing 3 will be the maxium of sports you could choose

<?php
if ($_POST['tennis']=="1" OR $_POST['reading']=="1" OR $_POST['basketball']=="1" OR $_POST['boxing']=="1" OR $_POST['football']=="1" OR $_POST['cricket']=="1") {
    if ($_POST['tennis']=="1" AND $_POST['reading']=="1" AND $_POST['boxing']=="1") {
        header('Location: [url="http://www.tennisreadingandboxing.com'%3b%29;"]http://www.tennisreadingandboxing.com');[/url]
    }
    if ($_POST['tennis']=="1" AND $_POST['reading']=="1") {
        header('Location: [url="http://www.tennisandreading.com'%3b%29;"]http://www.tennisandreading.com');[/url]
    }    
} else {
?>
<form id="myform" class="cssform" action="<?php echo $SERVER['PHP_SELF']; ?>" method="POST">
<p>
<label for="comments">Hobbies:</label><br>
<input type="checkbox" value="1" name="tennis"     class="threepxfix" /> Tennis<br />
<input type="checkbox" value="1" name="reading"    class="threepxfix" /> Reading <br />
<input type="checkbox" value="1" name="basketball" class="threepxfix" /> Basketball <br />
<input type="checkbox" value="1" name="boxing"     class="threepxfix" /> Boxing<br />
<input type="checkbox" value="1" name="football"   class="threepxfix" /> Football<br />
<input type="checkbox" value="1" name="cricket"    class="threepxfix" /> Cricket <br />
</p>
<div style="margin-left: 150px;">
<input type="submit" value="Submit">
<input type="reset" value="reset" />
</div>

</form>
<?php
}
?>

[ripken204]

well do you have a database yet? i can easily write the query code but i would need to know how it is all structured..

[smartie91]

thankyou

yes we have a temporary one at the moment to see if we can do this i could pm you the password and name if you like

thanks again

smartie91