Update Timestamp problem

bengt

Hello there

I've created a table where there is a 'edited' field that is a timestamp. How can I update this timestamp with the now() feature? Have tried searching this forum, and php.net. But can't find anything useful...

Anybody???

ex1

 
$time = now();
$query = "INSERT INTO tablename (columnname) VALUES '$time' ";
$result = mysql_query;

i think that will work. hope it helps,

david*

bengt

That didn't work...
When trying i'm receiving this error

Fatal error: Call to undefined function: now() in C:\webroot\htdocs\auksjon\admin\news_edit.php on line 59

Anyone else?

bengt

I solved my problem with this

$time = $currenttime[year].str_pad($currenttime[mon], 2, "0", STR_PAD_LEFT).str_pad($currenttime[mday], 2, "0", STR_PAD_LEFT).str_pad($currenttime[hours], 2, "0", STR_PAD_LEFT).str_pad($currenttime[minutes], 2, "0", STR_PAD_LEFT).str_pad($currenttime[seconds], 2, "0", STR_PAD_LEFT);

Is there a way to make this shorter?

ex1

use the time() function thing;

that will insert an UNIX time stamp that you can manipulate when you chose to display it.

so...

$time = now();
$query = "INSERT INTO tablename (columnname) VALUES '$time' ";
$result = mysql_query;

to convert the date into something readable do...

strftime("%d/%m/%y", yourdate)

hope that helps

david*

Drakla

Yeah you can insert a timestamp with the internal SQL function now

insert into foo (field) VALUES (NOW());

But remember if you're doing an update on other values in the same record the timestamp will be automatically updated to the current time anyway (as long as it's the first timestamp if you have more than one).