Passing Variables to specific Field

I know this should be easy but I’m just learning…

I have a variable chosen from a drop down list ($team_name).
I also have a form to input some values into the database.
What I’m trying to do is input those values into the table row that contains “$team_name”.

I have everything set up except for the statement that tells the form which row to post the values.

Can anyone let me know how to do this?
Thanks!

this is the code I’ve tried with no success:
[php]<?php

header(“Location: admin_enterteams.php”);

include(“opendatabase.php”);

$team = $_POST[‘team’];
$owner = $_POST[‘Owner’];
$email = $_POST[‘Email’];
$pd = $_POST[‘Paid’];

mysql_query(“UPDATE teams SET owner=$owner, email=$email, owner_pd=$pd WHERE team_name = $team”);

mysql_close($con);

?>
[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service