MYSQL database problems please help me

[jaytblack]

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!!!

 

[nasaboy007]

im not sure i understand your question properly, but here's my try.

if you have a variable amount of options that you need to record, you it could be that you wanna just have 2 fields (one for the name and one for the value) and have each element separated by some unique character, like a | or something. then when you write your code, just have it parse the two fields so that they match up properly.

dunno if that actually helps... and sorry if it doesnt.

 

[mrjohn]

Do I spot a .ASP file in that form? I have never heard of anyone mixing .ASP with MySQL.

The closest I've ever come is using a MySQL database connector with Visual BASIC .NET for a scangun program I wrote that has to integrate with a PHP website.

I only mention this because I find it highly unlikely that a person new to coding could intentionally mix ASP and MySQL.