how to ran a timestamp?

GFX__

i need to know what should i do to add a timestamp to my mysql db, what i want to do is make a countback to 0 of each row of my db

vaaaska

Add now() to your value field for the timestamp. Oh, and be sure the table is set to the right date/time type.

But, what's a countback?

GFX__

i mean countdown sorry.

could u pls put an example of what u mean? thanks

dalecosp

// use a MySQL function to insert a MySQL timestamp into a date/time field

$qry="update some_table set my_timestamp = now() where my_key='foo'";
$res=mysql_query($res);

// use PHP to insert a UNIX timestamp into a field (could be many types, varchar, text, int,
// bigint, etc.  Keep in mind that the time since the epoch was 1137580839 as of this
// writing, so you need at least that big a field....

$qry="update some_table set my_timestamp = ". time() ."where my_key='foo'";
$res=mysql_query($res);

I prefer the latter, as I can concentrate less on MySQL's language and more on PHP, but YMMV, of course, and the best programmers are quite comfortable with either usage. The latter probably has the disadvantage of using a tad more storage, but I'm not sure about this; it's possible that MySQL actually uses a UNIX timestamp internally to store the data, anyway.....