Updating/Inserting

[Solar]

$RETVAL For example;

$_POST['username'], $_POST['password'], $_POST['email'], $_POST['age'], $_POST['gender'], $_POST['status'], $_POST['about']/*..etc

/* Account edit successful */
      if($retval){
         $_SESSION['useredit'] = true;
         header("Location: ".$session->referrer);
      }

 

After a user has edit their profile; I would like from a different table from the same database to update itself saying "Solar has updated their profile".

The table for user's information is "login" and the table I want to update as well is called "update"

 

I would love the table "update" to look like this (allready made, just need it to be inserted);

idnamedescription

1Solarhas updated their profile.

2Stevenhas updated their profile.

 

I was thinking something like this;

mysql_query("INSERT INTO update (name, description)
VALUES ('$session->username', 'has updated their profile')");

 

But I am having problems putting this puzzle together. I would be happy if someone can get me started

 

P.s. Would I have to close off the first mysql connection before making another one? Or would that work. If there is a mysql code that could also do this trick automatically, that would be amazing!

 

Thanks in advanced!

[siric]

At first glance, looks ok to me.  What exact problems are you having?? Have you tried it??

[Solar]

Yes, Nothing is updating in the "update" table.. I will keep messing around.. I thought I was coding properly, I may have a mis-spelling problem. I will keep checking my coding.

[Solar]

LAWL. Imma idiot. Teehee.

 

I have a table called Update... The $SQL was trying to update a row that did not exist, I renamed the table and now its doing what I want it to do.