View Single Post
  #1 (permalink)  
Old 2008-04-15, 06:24 AM
flforlife flforlife is offline
Junior Member
 
Join Date: Apr 2008
Posts: 7
flforlife is on a distinguished road
Default Insert multple records in a table pt2 !!!!

ok I have the code here input page......


<tr>
<td><input name="entry[0][place]" type="text" /></td>
<td><input name="entry[0][team]" type="text" /></td>
<td><input name="entry[0][wl]" type="text" /></td>
<td><input name="entry[0][gb]" type="text" /></td>
<td><input name="entry[0][pcage]" type="text" /></td>
<td><input name="entry[0][rs]" type="text" /></td>
<td><input name="entry[0][ra]" type="text" /></td>
<td><input name="entry[0][ags]" type="text" /></td>
</tr>

<tr>
<td><input name="entry[1][place]" type="text" /></td>
<td><input name="entry[1][team]" type="text" /></td>
<td><input name="entry[1][wl]" type="text" /></td>
<td><input name="entry[1][gb]" type="text" /></td>
<td><input name="entry[1][pcage]" type="text" /></td>
<td><input name="entry[1][rs]" type="text" /></td>
<td><input name="entry[1][ra]" type="text" /></td>
<td><input name="entry[1][ags]" type="text" /></td>
</tr>


this is add.php code....

foreach($_POST['sql']){

sql = $_POST["entry"][0] = array("place"=>"...", "team"=>"...");

sql = $_POST["entry"][1] = array("place"=>"...", "team"=>"...");
$result = mysql_query($sql);
}


I get an error message! Is it the foreach loop or should I use for loop?
Reply With Quote