[SOLVED] Field Variable?

[Skittalz]

When using a MySQL UPDATE, is it possible to use a variable as the field name as well as a variable for the field value? My field name is in a loop and I am trying to update my MySQL column values...

 

Heres my code

 

 

@mysql_query("INSERT INTO statistics_past(`startdate`) VALUES ('".date("Y-m-d H:i:s")."') ");

  $sql = mysql_query("SELECT * FROM statistics_past"); 
  $Mr = mysql_num_rows($sql); 


  $result = mysql_query("SELECT * FROM statistics");

  while($row = mysql_fetch_array($result)) {
$id = (int) $row['id'];
echo $Mr. " - ".$id;

@mysql_query("UPDATE statistics_past SET '".$id."' = '".$row['w_views']."' WHERE id = '" . mysql_real_escape_string($Mr). "'");
  }
  @mysql_query("UPDATE statistics_past SET `enddate` = ('".date("Y-m-d H:i:s")."') WHERE id = '" . mysql_real_escape_string($Mr - 1). "'");  

 

Any help would be appreciated ... I've been looking at this code for to long ... Thanks!

 

Steve

[fenway]

MySQL doesn't know about php variables.  Which query are we talking about?  Does one not work? You're absorbing errors.

[Skittalz]

@mysql_query("UPDATE statistics_past SET '".$id."' = '".$row['w_views']."' WHERE id = '" . mysql_real_escape_string($Mr). "'");

 

This MySQL doesn't work 

[Skittalz]

Nevermind I figured it out

 

The problem was I was using single quotes (') around the field name when I shoulda been using a grave accent (`) ....

 

good ole php n mysql