adding code to db using an array

[runnerjp]

Below is the full code to add races to my db.

 

<link rel="stylesheet" href="http://www.runningprofiles.com/dad/Form.Send/demo.css" type="text/css" />

<script type="text/javascript" src="http://www.runningprofiles.com/dad/mootools.js"></script>

<script type="text/javascript" src="http://www.runningprofiles.com/dad/Form.Send/demo.js"></script>



<script> 



function addRow() {   

          var tbl = document.getElementById('thetable');   

          var lastRow = tbl.rows.length;   

          var row = tbl.insertRow(lastRow);   

             

          var cell1 = row.insertCell(0);   

                  cell1.setAttribute('align','center') 

          var input = document.createElement('input');   

          input.name = 'date' + lastRow;   

          input.id = 'date' + lastRow;   

          cell1.appendChild(input);  



var cell2 = row.insertCell(1);   

                cell2.setAttribute('align','center') 

          input = document.createElement('input');   

          input.name = 'goals' + lastRow;   

          input.id = 'goals' + lastRow;   

          cell2.appendChild(input);  

             

          var cell3 = row.insertCell(1);   

                cell3.setAttribute('align','center') 

          input = document.createElement('input');   

          input.name = 'venue' + lastRow;   

          input.id = 'venue' + lastRow;   

          cell3.appendChild(input);   

  

var cell4 = row.insertCell(1);    

                cell4.setAttribute('align','center'); 

                 

                input = document.createElement('select');    

                input.name = 'terrain' + lastRow; 

                input.id = 'terrain' + lastRow; 

                 

                var s = "Road/Track/Multi Terrain/Cross Country".split("/"); 

                for(var i=0;i<s.length;i++) { 

                        var o = document.createElement("option"); 

                        o.value = s[i]; 

                        o.text = s[i]; 

                        input.add(o); 

                } 

         

                cell4.appendChild(input); 

        var cell5 = row.insertCell(1);    

                cell5.setAttribute('align','center'); 

                 

                input = document.createElement('select');    

                input.name = 'distance' + lastRow; 

                input.id = 'distance' + lastRow; 

                 

                var s = "3000m/5000m/10,000m/5 Miles/10 Miles/20 Miles/Half Marathon/Marathon /Other".split("/"); 

                for(var i=0;i<s.length;i++) { 

                        var o = document.createElement("option"); 

                        o.value = s[i]; 

                        o.text = s[i]; 

                        input.add(o); 

                } 

         

                cell5.appendChild(input); 

  

} 



    function delRow() {  

          var tbl = document.getElementById('thetable');   

          var lastRow = tbl.rows.length;   

          if (lastRow > 2) tbl.deleteRow(lastRow - 1);   

     } 





</script>

<br />

<center>

Here is a list of you up and coming races. Use the form below to add them so then <b>I</b> know which races you have gone for!



</center>

    <br />

<table width = "99%" class = 'forum'> 

                <tr> 

                    <td> 

                        <table width="100%" class = 'maintable'> 

                            <tr class = 'headline'> 

                            <td width = "12%" bgcolor="#003366"> 

                                    <div align = "center">Date</div></td> 



                                <td width = "14%" bgcolor="#003366"> 

                                   <div align = "center">Terrain</div></td> 



                                <td width = "12%" bgcolor="#003366"> 

                                     <div align = "center">Distance</div>                                   </td> 



                                <td width = "43%" bgcolor="#003366"> 

                                    <div align = "center">Venue

                                    </div></td> 



                                <td width = "19%" bgcolor="#003366"> 

                                    <div align = "center">Goals</div></td> 

                            </tr> 



                        <?php 

//$query="DELETE FROM dad WHERE id = '22' ";

//$result=mysql_query($query);



                                                 $getthreads = 

                                "Select * from races ORDER BY date ASC"; 



                            $getthreads2=mysql_query($getthreads) or die("Could not get threads"); 



                            while ($getthreads3=mysql_fetch_array($getthreads2)) 

                                { 

                                 

                      

                                ?><tr <? if ( $getthreads3['date'] == date("d/m/Y") ) { echo 'bgcolor="#CAD9D9"'; }?> > 

<td width="10%" height="39" align="center" valign="middle"><?php 

                            echo $getthreads3['date'];?> 



                                </td>  

<td width="15%" align="center" valign="middle"> <?php echo $getthreads3['distance']; ?>  

                                </td>   

<td width="15%" align="center" valign="middle"><?php echo $getthreads3['terrain']; ?>  

                       </td><td align = "center" valign = "middle"><?php echo $getthreads3['venue']?> </td> 



                                <td align="center" valign = "middle"> 

<?php echo $getthreads3['goals']?>



</td> 



                       

                                    </tr> 

                            <?php      } 

                        ?> 

                  </table></td> 

                </tr> 

</table>

    



<form id="myForm" action="Form.Send/ajax.form.php" method="post">

    

     <table align="center" style="WIDTH: 100%;BACKGROUND: #C0C0C0; BORDER-COLLAPSE: collapse" id="thetable"> 

   <tbody> 

     <tr> 

       <td> 

         <p align="center">Date</p></td> 

       <td> 

         <p align="center">Distance</p></td> 

       <td> 

         <p align="center">Terrain</p></td>

<td> 

         <p align="center">place</p></td>  

       <td> 

         <p align="center">Goals</p></td> 

    </tr> 

     <tr> 

       <td align="center"> 

        <input  name="date" value="<?php echo date("d/m/Y");?> " /></td> 

       <td align="center">

        <select name="distance">

<option value="3000m">3000m</option>

<option value="5000m">5000m</option>

<option value="10,000m">10,000m</option>

<option value="5 Miles">5 Miles</option>

<option value="10 Miles">10 Miles</option>

<option value="20 Miles">20 Miles</option>

<option value="Half Marathon">Half Marathon</option>

<option value="Marathon">Marathon</option>

<option value="Other">Other</option>

</select>

         </td> 

       <td align="center"> 

       <select name="terrain">

<option value="Road">Road</option>

<option value="Track">Track</option>

<option value="Multi Terrain">Multi Terrain</option>

<option value="Cross Country">Cross Country</option>

</select>

</td> 

       <td align="center"> 

        <input  name="venue" /></td> 

<td align="center"> 

        <input  name="goals" /></td> 

    </tr> 

  </tbody> 

</table> 

<table style="WIDTH: 100%; BORDER-COLLAPSE: collapse"> 

     <tr> 

       <td> 

       <p align="center"> 

          <input type="button" value="Add Anouther" onclick="addRow()" /> 

          <input type="button" value="Subtract Row" onclick="delRow()" /> 

                </p> 

       </td> 

    </tr> 

</table> 



<center>



		<input type="submit" name="button" id="submitter" /></center>

	<span class="clr"><!-- spanner --></span>

	</div>

        

        

        

</form>

    

    <center>

    

    

<div id="log">

	<center><h3>Ajax Response</h3>

	<div id="log_res"><!-- spanner --></center></div>

</div>

</center>

<span class="clr"><!-- spanner --></span>

 

 

As you can see there is an option to add a number of rows so you can add more than 1 race... what would i need to do to add all races the user inputs?? a loop of some kind?

[runnerjp]

ver dump gets me

 

Array

(

    [date] => 14/03/2010

    [venue] => 1

    [goals] => 1

    [date2] => 14/03/2010

    [venue2] => 2

    [goals2] => 2

    [date3] => 14/03/2010

    [venue3] => 3

    [goals3] => 3

    [distance] => 5000m

    [terrain] => Road

    [distance2] => 3000m

    [terrain2] => Track

    [distance3] => 10,000m

    [terrain3] => Cross Country

)

 

if that helps at all