code stopped working

[searls03]

Why has this code stopped working, i had it working, but now it is not...........It is an update profile page but when i click save, it is trying to post my username to the database instead of the persons I am updating......help!!!!!!!!

 

<?php
}
//action: edit user -----------------------------------------------------------------------------
if (isset($_GET['edit']) && isset($_GET['id'])) {
$userid = (int) $_GET['id'];
if ($userid == 0) {
	die("Invalid ID provided.");
}
//execution when completed the edit user form and pressed submit button ---------------------
if (isset($_POST['editUser'])) {
	//validate data ------------------------------------------------------------------------


	//check email validation, the function is available at config.php

	//check both passwords are the same when password fields are not empty

	//end validate data ---------------------------------------------------------------------

	//save to database when no errors are detected ------------------------------------------
	if (count($error) == 0) {
		$query = "UPDATE members SET username='".$username."', email='".$email."',name='".$name."', phone='".$phone."',address='".$address."', city='".$city."',state='".$state."', zip='".$zip."',cell='".$cell."', accounttype='".$accounttype."',badges='".$badges."', rank='".$rank."' WHERE userid='".$userid."' ";



		//update username session if you edit yourself
		if ($userid == $_SESSION['auth_admin_userid']) {
			$_SESSION['auth_admin_username'] = $username;
		}

		if (mysql_query($query)) {
			echo "<p><strong>User has been edited and saved to the database.</strong></p>";
		} else {
			echo "<strong>User has NOT been edited and saved into the database. ".mysql_error()."</strong>";
		}
	}
}
//get user from the database and put data into $_POST variables.
$rs = mysql_query("SELECT name, username, phone, address, city, state, zip, cell, email, badges, rank, accounttype FROM members WHERE userid = ".$userid."");
if (mysql_num_rows($rs) == 0) {
	die("User does not exists!");
}
$row = mysql_fetch_assoc($rs);
$_POST['name'] = $row['name'];
	$_POST['username'] = $row['username'];
$_POST['phone'] = $row['phone'];
	$_POST['address'] = $row['address'];
$_POST['city'] = $row['city'];
$_POST['state'] = $row['state'];
$_POST['zip'] = $row['zip'];
$_POST['cell'] = $row['cell'];
$_POST['email'] = $row['email'];
	$_POST['badges'] = $row['badges'];
$_POST['rank'] = $row['rank'];
	$_POST['accounttype'] = $row['accounttype'];


//if is admin, then $_POST['admin'] exists


?>







<div id="TabbedPanels1" class="TabbedPanels">
  <ul class="TabbedPanelsTabGroup">
    <li class="TabbedPanelsTab" tabindex="0">My Info</li>
    <li class="TabbedPanelsTab" tabindex="0">Merit Badges</li>
    <li class="TabbedPanelsTab" tabindex="0">Scout Rank</li>
    </ul>
  <div class="TabbedPanelsContentGroup">
    <div class="TabbedPanelsContent">
    <form action="admin.php?edit&id=<?php echo $userid;?>" method="post">
      <table align="center" cellpadding="8" cellspacing="8">
        <tr>  
          <td><div align="right">Name:</div></td>
          <td>	<p><input type="text" name="name" value='<?php echo $_POST['name'];?>' />
	<?php echo(isset($error['name']))?$error['name']:"";?></p></td>
          </tr>
        <tr>
          <td>Phone Number:</td>
          <td><input type="text" name="phone" value='<?php echo $_POST['phone'];?>' />
	<?php echo(isset($error['phone']))?$error['phone']:"";?></td>
          </tr>  
        <tr>
          <td><div align="right">Address:</div></td>
          <td><input type="text" name="address" value='<?php echo $_POST['address'];?>' />
	<?php echo(isset($error['address']))?$error['address']:"";?></td>
          </tr>
        <tr>
          <td><div align="right">City:</div></td>
          <td><input type="text" name="city" value='<?php echo $_POST['city'];?>' />
	<?php echo(isset($error['city']))?$error['city']:"";?></td>
          </tr>
        <tr>
          <td><div align="right">State:</div></td>
          <td><input type="text" name="state" value='<?php echo $_POST['state'];?>' />
	<?php echo(isset($error['state']))?$error['state']:"";?></td>
          </tr>  
        <tr>
          <td><div align="right">Zip Code:</div></td>
          <td><input type="text" name="zip" value='<?php echo $_POST['zip'];?>' />
	<?php echo(isset($error['zip']))?$error['zip']:"";?></td>
          </tr>
        <tr>
          <td><div align="right">Email:</div></td>
          <td>	
	<p>
	<input type="text" name="email" value='<?php echo $_POST['email'];?>' />
	<?php echo(isset($error['email']))?$error['email']:"";?></p></td>
          </tr> 
        <tr>
          <td><div align="right">Cell Phone:</div></td>
          <td><input type="text" name="cell" value='<?php echo $_POST['cell'];?>' />
	<?php echo(isset($error['cell']))?$error['cell']:"";?></td>
          </tr>  
        <tr>
          <td class="aaaaaaa" align="right">Username:</td>
          <td><label for="username"></label>
            <input type="text" name="username" value='<?php echo $_POST['username'];?>' />
	<?php echo(isset($error['username']))?$error['username']:"";?></p>
            </td>
          </tr>
      
        </table>
      <p>         </p>
      
        <input name="editUser" type="submit" value="Save" />
        <input type="hidden" name="userid" value="<?php echo $userid; ?>" />
      
    </form>  
      </div>
    <div class="TabbedPanelsContent">
      <label for="badges"></label>
      <input name="badges" type="text" id="badges" value="<?php echo "$badges"; ?>" />
      </div>
    <div class="TabbedPanelsContent">
      <input name="rank" type="text" id="rank" value="<?php echo $rank; ?>" />
      </div>
    </div>
</div> <script type="text/javascript">
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
  </script>
<?php
}
?>

[searls03]

does this make sense?

[kenrbnsn]

If the code was working and now it's not, something changed. Did you change any code?

 

Ken

[searls03]

yeah, just a little bit, I am trying to start from beginning and trace my steps to see what i did wrong unless you see it.

[searls03]

ok, so if I get rid of it posting username in the update field, it works fine...........if not, it doesn't,  how can I fix this.......