S.O.S reaching out to all namepros members who can help me.
I'm new to code writing and right now im taking on something that's more advance for my level but needs to be done and would like if anybody can help me make this possible.
what im trying to do is create a mysql database that would respond to multiple check box choices, i already understand how to code the check boxes but my problem is how would i set up the database and table so that they would be compatible. if you can help me using this as an example of what my system would look like that would be much appreciated.
<form name="input" action="html_form_action.asp" method="get">
<input type="checkbox" name="type" value="series" />series
<input type="checkbox" name="type" value="movie" />movie
<input type="checkbox" name="genre" value="action" />action
<input type="checkbox" name="genre" value="adventure" />adventure
<input type="checkbox" name="genre" value="drama" />drama
<input type="checkbox" name="genre" value="comedy" />comedy
<input type="submit" value="Submit" />
</form>
i need the values of the checkboxes to be able to pull up multiple rows(records) based on whats been checked, i dont know in what way should i set up the database with the information where it can be called based on the check box, how many tables would be involved? would a foreign key be needed? would i need to specify the values 0,1 and null? if so where? i have so many questions with no answers please help if you can!!!
I'm new to code writing and right now im taking on something that's more advance for my level but needs to be done and would like if anybody can help me make this possible.
what im trying to do is create a mysql database that would respond to multiple check box choices, i already understand how to code the check boxes but my problem is how would i set up the database and table so that they would be compatible. if you can help me using this as an example of what my system would look like that would be much appreciated.
<form name="input" action="html_form_action.asp" method="get">
<input type="checkbox" name="type" value="series" />series
<input type="checkbox" name="type" value="movie" />movie
<input type="checkbox" name="genre" value="action" />action
<input type="checkbox" name="genre" value="adventure" />adventure
<input type="checkbox" name="genre" value="drama" />drama
<input type="checkbox" name="genre" value="comedy" />comedy
<input type="submit" value="Submit" />
</form>
i need the values of the checkboxes to be able to pull up multiple rows(records) based on whats been checked, i dont know in what way should i set up the database with the information where it can be called based on the check box, how many tables would be involved? would a foreign key be needed? would i need to specify the values 0,1 and null? if so where? i have so many questions with no answers please help if you can!!!
