Date,time resets every time i use UPDATE

Question

Date, time resets every time i use UPDATE,

page1

mysql_query("INSERT INTO table (time) VALUES(CURRENT_TIMESTAMP()) ") or die(mysql_error());

page2 (not connected with page1)

echo $row['time'];

and after i use

$query = mysql_query("UPDATE tablica SET views = views+1 WHERE id = '".$id."' ");

date and time resets to current date and time and if i delete UPDATE code everything is fine, type is timestamp, how to stop reseting date and time?

Can you show the `SHOW CREATE TABLE` output? – marekful May 07 '14 at 09:39 — marekful, May 07 '14 at 09:39
Store the time in session – Alaa Badran May 07 '14 at 09:41 — Alaa Badran, May 07 '14 at 09:41
Set the type to datetime instead? – putvande May 07 '14 at 09:42 — putvande, May 07 '14 at 09:42

score 0 · Accepted Answer · edited May 23 '17 at 12:20

0

If table field is defined as timestamp, then it'll update automatically when record is changed / updated.

Read more about timestamps and issues here:

edited May 23 '17 at 12:20

Community

answered May 07 '14 at 09:44

DarkSide

man...everybody say timestamp is the best so i put it didnt,know this is part of it, anyway, tnx! – user2061082 May 07 '14 at 13:15
Timestamp is useful in some cases, but to really use it you first need to understand every aspect of it in MySQL DB. Simplest usage is for `last_time_updated` type of fields, but timestamp can be used in other cases too. Note, that it's hard (MySQL issues) to use more than one timestamp field in table. – DarkSide May 07 '14 at 22:18

1 Answers1