Code: Select all
<?php
include("opendatabase.php");
----drop down list----
$query="SELECT team_name FROM teams";
$result = mysql_query ($query);
echo "<select name=\"team\"></option>";
while($team=mysql_fetch_array($result))
{
echo "<option value=$team[team_name]>$team[team_name]</option>";
}
echo "</select>";
mysql_close($con)
?>
Code: Select all
<FORM Method = "POST" action ="insert_teams.php">
Owner: <INPUT TYPE = "text" size="35" name ="Owner">
Paid: <INPUT TYPE = "text" size="10" name = "Paid">
<br /><br />
E-Mail: <INPUT TYPE = "text" size="50" name ="Email">
<input type="submit" name="Submit" value="Submit">
</FORM>
<br />
Code: Select all
<?php
header("Location: admin_enterteams.php");
include("opendatabase.php");
$team = $_POST['team'];
$owner = $_POST['Owner'];
$email = $_POST['Email'];
$pd = $_POST['Paid'];
$query="UPDATE teams SET owner='$owner' email='$email' owner_pd='$pd' WHERE team_name = '$team' ";
$result=mysql_query($query);
if(!$result){
echo " Unable to update your database";
}else{
echo "Your database updated successfuly";
}
mysql_close($con);
?>