[RESOLVED] Timestamp

[asa_carter]

Hi all,

In MySQL I have a field called "date_time" of type "timestamp" with a default value of "CURRENT_TIMESTAMP".

However, when using this query it does not insert the current timestamp:

$query = "INSERT INTO bid_history VALUES ('$id','$valid_user','$bid','$nextbid','')";
$result = mysql_query($query);

The last field is the time stamp. Any idea's what i'm doing wrong?

[Roger_Ramjet]

Yes, you are overriding the default with your empty string ...bid','')". If you want to let a column default to it's default value then you omit it from the insert query, TOTALLY.

I can never understand why people think they need to include some sort of placeholder for columns with no input because there is nothing in the manual to suggest that you might need one. ????

[Houdini]

They assigned a value of ...well nothing to it, so it was just obeying the query.

[asa_carter]

Hi,

I did try omitting it from the query like you said but it still didn't seem to work.

I got working by using the now() function.