[SOLVED] timestamp updates by itself?

[JP128]

I made a change password script, and when the user clicks submit, it automatically updates the date_joined to the current time... is there anyway to stop this?

[chiprivers]

Where is your script? You must have set it to update the column holding this information!

[JP128]

$password = $_POST['password'];
mysql_query("UPDATE users SET password=md5('$password') WHERE username='$username'");
}
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$biography = $_POST['biography'];
$location = $_POST['location'];
mysql_query("UPDATE users SET firstname='$firstname' WHERE username='$username'");
mysql_query("UPDATE users SET lastname='$lastname' WHERE username='$username'");
mysql_query("UPDATE users SET email='$email' WHERE username='$username'");
mysql_query("UPDATE users SET biography='$biography' WHERE username='$username'");
mysql_query("UPDATE users SET location='$location' WHERE username='$username'");
}

[chiprivers]

I just had a look at MySQL reference and you can set the column in your database table to update with the current time stamp when the record is updated, you must have done this! You will need to amend the relevent column:

ALTER TABLE tablename MODIFY columnname DATETIME

Above is the syntax to change the data type of your relevant column to a datetime value without any additional auto update settings.

[JP128]

Thanks, that worked like a charm.

[chiprivers]

I had to do another post so that I gone one more total posts than you JP128!!  ;D ;D

[JP128]

Hah, I made a new topic, and with this post, 141! yah!