how do i add this to a data base

[chris_s_22]

this is a form that once filled to make enteries into my database, firstly what tables feild names do i need, secondly what do i add to my functions.php page thirdly what will be entered in my creategame.php

<form action="creategame.php" method="post">   

<input type='text' name='players0' size='35' value='Player 1'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players1' size='35' value='Player 2'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players2' size='35' value='Player 3'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players3' size='35' value='Player 4'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players4' size='35' value='Player 5'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players5' size='35' value='Player 6'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players6' size='35' value='Player 7'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players7' size='35' value='Player 8'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players8' size='35' value='Player 9'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players9' size='35' value='Player 10'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players10' size='35' value='Player 11'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players11' size='35' value='Player 12'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players12' size='35' value='Player 13'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players13' size='35' value='Player 14'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
<input type='text' name='players14' size='35' value='Player 15'>
<select><option value='M'>Male</option><option value='F'>Female</option></select><br>
Select a  tareget score<select name="finalscore">
     <option>20</option>
     <option>25</option>
     <option>30</option>
	 <option>35</option>
     <option>40</option>
     <option>45</option>
     <option>50</option>
     <option>55</option>
     <option>60</option>
	 <option>65</option>
     <option>70</option>
     <option>75</option>
	 <option>80</option>
     <option>85</option>
     <option>90</option>
	 <option>55</option>
     <option>100</option>
	 </select>
<input type="submit" name="submit" value="PLAY GAME" />
</form>

[sfullman]

Hi Chris,

I see you're new to the forum. They used to have a sticky on "how to ask for help" - the normal way to ask for help (though not always) is to say "hey I'm doing x and y doesn't work" - usually a very specific thing which doesn't work. If you keep your questions bite-sized and give all the code relevant to that SPECIFIC problem.

You are asking 3 questions and people would have to guess at helping you due to the ambiguity.

I can say that your HTML code has a problem: none of the <select> elements have name="gender1[2,3,etc.]" in them so I'm not sure how you could tie them into a database -

also, there about 9,398,285 different ways to take the form data you have (assuming you add gender1,2,3 etc.)

I hope I am being of help to you.

Samuel