Form processing problem.

[Mark_Nordstrom]

<?
$yourteam = $_POST['yourteam'];
$histeam = $_POST['histeam'];
$playerb = $_POST['playerb'];
$playera = $_POST['playera'];

UPDATE test SET teamid='$histeam' WHERE name ='$playera';
UPDATE test SET teamid='$yourteam' WHERE name ='$playerb'
?>

I get an error with this on the first UPDATE line whats wrong ?

this is the form

<form name="form1" method="post" action="trade1.php">
  <p> 
    <select name="playera" id="playera">
      <?php
do {  

?>
      <option value="<?php echo $row_players['name']?>"<?php if (!(strcmp($row_players['name'], $row_players['name']))) {echo "SELECTED";} ?>><?php echo $row_players['name']?></option>
      <?php
} while ($row_players = mysql_fetch_assoc($players));
  $rows = mysql_num_rows($players);
  if($rows > 0) {
      mysql_data_seek($players, 0);
	  $row_players = mysql_fetch_assoc($players);
  }
?>
    </select>
    FOR 
    <select name="playerb" id="playerb">
      <?php
do {  

?>
      <option value="<?php echo $row_bos['name']?>"<?php if (!(strcmp($row_bos['name'], $row_bos['name']))) {echo "SELECTED";} ?>><?php echo $row_bos['name']?></option>
      <?php
} while ($row_bos = mysql_fetch_assoc($bos));
  $rows = mysql_num_rows($bos);
  if($rows > 0) {
      mysql_data_seek($bos, 0);
	  $row_bos = mysql_fetch_assoc($bos);
  }
?>
    </select>
  </p>
  <table width="24%" border="0">
    <tr>
      <td width="43%"><select name="yourteam" id="select">
          <?php
do {  

?>
          <option value="<?php echo $row_team['teamid']?>"<?php if (!(strcmp($row_team['teamid'], $row_team['teamid']))) {echo "SELECTED";} ?>><?php echo $row_team['teamid']?></option>
          <?php
} while ($row_team = mysql_fetch_assoc($team));
  $rows = mysql_num_rows($team);
  if($rows > 0) {
      mysql_data_seek($team, 0);
	  $row_team = mysql_fetch_assoc($team);
  }
?>
        </select> </td>
      <td width="57%"> 
        <select name="histeam" id="select3">
          <?php
do {  

?>
          <option value="<?php echo $row_bos['teamid']?>"<?php if (!(strcmp($row_bos['teamid'], $row_bos['teamid']))) {echo "SELECTED";} ?>><?php echo $row_bos['teamid']?></option>
          <?php
} while ($row_bos = mysql_fetch_assoc($bos));
  $rows = mysql_num_rows($bos);
  if($rows > 0) {
      mysql_data_seek($bos, 0);
	  $row_bos = mysql_fetch_assoc($bos);
  }
?>
        </select></td>
    </tr>
  </table>
  <p>&nbsp; </p>
  <p>
    <input type="submit" name="Submit" value="Submit">
  </p>
  <p>&nbsp;</p>
</form>

[altexis]

try this:

<?
$yourteam = $_POST['yourteam'];
$histeam = $_POST['histeam'];
$playerb = $_POST['playerb'];
$playera = $_POST['playera'];

mysql_query("UPDATE test SET teamid='$histeam' WHERE name ='".mysql_escape_string($playera)."'") or die(mysql_error());
mysql_query("UPDATE test SET teamid='$yourteam' WHERE name ='".mysql_escape_string($playerb)."'") or die(mysql_error());
?>

[Mark_Nordstrom]

thanks man works perfect.