prevent time from updating

[rbragg]

This question will probably sound really stupid:

 

I am storing the date and time of an insertion into the db using now(). However, if I update any other fields/columns in the db later - that date/time is also updated. How can I prevent this?

 

Thanks in advance!

[trq]

Can we see your update statement? It should be a simple matter of not updating that field.

[rbragg]

I'm not dabbling with the time at all:

 

<?php
$queryUpdate = " 
UPDATE vigil_call
SET status = '$status'
WHERE callID = '$callID'
";
$update = mysql_query($queryUpdate);
?>

 

I imagine my problem is that the column need not be the timestamp type?

 

[taith]

$time=time();

 

then whenever you need a static time... use $time, instead of time()/now()

[Barand]

Sounds like the column is type TIMESTAMP, the purpose of which is to auto-update when the record is changed.

[taith]

oh... then no... no way of changing that... that i know of 

[rbragg]

I imagine my problem is that the column need not be the timestamp type?

 

Sounds like the column is type TIMESTAMP, the purpose of which is to auto-update when the record is changed.

 

We were right. Changing the type gave the result I needed. Thanks everyone for your help.