[Resolved] posted values not updating

[crawfd]

The second query is sticking the proper values per field, however upon submit, the values aren't updating? Don't see what I'm doing wrong here....

<?

if(($_POST['submit'])){

$db = @mysql_connect('localhost','','');
mysql_select_db('journals');

$query = "UPDATE users SET '".$_POST['gender']."'=gender, '".$_POST['age']."'=age, '".$_POST['location']."'=location, '".$_POST['email']."'=email, '".$_POST['website']."'=website, '".$_POST['yahooim']."'=yahooim, '".$_POST['msnim']."'=msnim, '".$_POST['aolim']."'=aolim, '".$_POST['icq']."'=Icqnum WHERE username = '".$_SESSION['username']."'"; 
mysql_query($query,$db);

} 

$query = "SELECT * FROM users WHERE username = '".$_SESSION['username']."'"; 
$res=mysql_query($query) or die("SQL: $query<br />\nError: ".mysql_error()); 
$row=mysql_fetch_array($res);
?>
<b><font size=3 color=#808080>Edit My Profile...</font></b><br><br/>
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<form method="POST" action="myjournal.php?page=manage&action=editmyprofile"> 
  <tr> 
    <td width="9%">Gender:</td>
    <td width="91%"><input type="text" name="gender" value="<?=$row['gender']?>"></td>
  </tr>
  <tr> 
    <td>Age:</td>
    <td><input type="text" name="age" value="<?=$row['age']?>"></td>
  </tr>
  <tr> 
    <td>Location:</td>
    <td><input type="text" name="location" value="<?=$row['location']?>"></td>
  </tr>
  <tr> 
    <td>Email:</td>
    <td><input type="text" name="email" value="<?=$row['email']?>"></td>
  </tr>
  <tr> 
    <td>Website:</td>
    <td><input type="text" name="website" value="<?=$row['website']?>"></td>
  </tr>
  <tr> 
    <td>Yahoo IM:</td>
    <td><input type="text" name="yahooim" value="<?=$row['yahooim']?>"></td>
  </tr>
  <tr> 
    <td>MSN IM:</td>
    <td><input type="text" name="msnim" value="<?=$row['msnim']?>"></td>
  </tr>
  <tr> 
    <td>AOL IM:</td>
    <td><input type="text" name="aolim" value="<?=$row['aolim']?>"></td>
  </tr>
  <tr> 
    <td>ICQ:</td>
    <td><input type="text" name="icq" value="<?=$row['Icqnum']?>"></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td><input type="submit" name="submit" value="Save Changes!"></td>
  </tr>
</form></table>

<? } ?>

[devinemke]

your name/value pairs are all reversed in your UPDATE SQL:

...SET '".$_POST['gender']."'=gender,...

should be:

...SET gender = " . $_POST['gender'] . ",...

[TheDefender]

Your update query is bass ackwards...

Instead of doing this:

$query = "UPDATE users SET '".$_POST['gender']."'=gender, '".$_POST['age']."'=age..........";

Do this:

$query = "UPDATE users SET gender = '".$_POST['gender']."', age = '".$_POST['age']."'......";

[crawfd]

oh, duh. Thanks that works....😃