I'm trying to get my MySql database to automatically enter in a timestamp when I insert data. Based on the structure/code below, I just get 0's in my dbTime column. Any thoughts would be appreciated...


Fields: log_id, tax_id, email, dbTime
Type: timestamp
Default: Current_Timestamp
Null: No

PHP Code:
    $log_query=mysql_query("INSERT INTO log VALUES ('','".$txn_id."','".$payer_email."','')");