Saving Timestamp Problem

[Anon]

I'm trying to capture a timestamp and write to the datebase. I figured since it returns an integer could do it anywhere in the app.

I chose to do it immediately before writing to the database. The code below saves the value 00000000000000 when run.

$current_time = time();

$add = "Insert into $tableName(report_number, user_name, project_number, date_report, timestamp )values ('$report_no', '$member', '$num', '$job_date', '$current_time' )";

Your help is greatly appreciated.

[rdhatt]

don't bother sending a value for the timestamp field -- it should automatically be filled with the time the row was last updated.