Stamp time : UPDATE?

[RON_ron]

Can I stamp the time when doing a UPDATE? Please show me how.

 

$SomeVar = $_POST['finco'];
mysql_query("UPDATE dxone SET und1='$cha', und2='$chb', und3='$chc' WHERE username = '".$SomeVar."'");

[joel24]

stamp the current time?

time(); returns current unix timestamp.

 

or do you want to use the time in the sql query somewhere?

[Pikachu2000]

If the field is the appropriate type, you can use `field` = NOW() in the query string. You can also alter the field, or add another field and define it with ON UPDATE CURRENT_TIMESTAMP. Look at MySQL's timestamp functions and I'm sure you'll find the right way for your application.