Here is the first code before the submission.
Code: Select all
<?php
require($_SERVER["DOCUMENT_ROOT"]."/config/db_config.php");
$connection = @mysql_connect($db_host, $db_user, $db_password) or die("Error Connecting");
mysql_select_db ("censored");
//build query
$query = mysql_query("SELECT * FROM SchoolBoysRunEvents where id = 1");
$array = mysql_fetch_row($query);
$total1 = $array[1];
$total2 = $array[2];
$total3 = $array[3];
$total4 = $array[4];
$total5 = $array[5];
$total6 = $array[6];
echo '<form method="post" action="updateit.php" />';
echo '<table width="300" height="132" border="0">';
echo '<tr>
<td>School</td>
<td>100m</td>
<td>200m</td>
<td>400m</td>
</tr>
<tr>
<td><textarea name="School" cols="10" rows="5">'.$total1.'</textarea></td>
<td><textarea name="e100m" cols="20" rows="5">'.$total2.'</textarea></td>
<td><textarea name="e200m" cols="20" rows="5">'.$total3.'</textarea></td>
<td><textarea name="e400m" cols="20" rows="5">'.$total4.'</textarea></td>
</tr>
</table><br><br>';
echo '<table width="300" height="132" border="0">';
echo '<tr>
<td>800m</td>
<td>e110m</td>
</tr>
<tr>
<td><textarea name="e800m" cols="20" rows="5">'.$total5.'</textarea></td>
<td><textarea name="e110m" cols="20" rows="5">'.$total6.'</textarea></td>
</tr>
</table>';
echo '<br><br><input type="submit" value="Update" />';
echo '</form>';
mysql_close($connection);
?>Code: Select all
<?php
$school = $_GET['School'];
$e100m = $_GET['e100m'];
$e200m = $_GET['e200m'];
$e400m = $_GET['e400m'];
$e800m = $_GET['e800m'];
$e110m = $_GET['e110m'];
require($_SERVER["DOCUMENT_ROOT"]."/config/db_config.php");
$connection = @mysql_connect($db_host, $db_user, $db_password) or die("Error Connecting");
mysql_select_db ("censored");
//build query
$query = mysql_query("INSERT INTO SchoolBoysRunEvents (school, 100, 200, 400, 800, e110m)
VALUES('".$school."', '".$e100m."', '".$e200m."', '".$e400m."', '".$e800m."', '".$e110m."') where id = 1");
mysql_close($connection);
?>