INSERTing time();

Im inserting current time into the database, and the first time it worked. But now it just inserts 00000000000000 (But now every single one is 20031130084338)

How can I sort this problem out? It's quite annoying since when listing it on a another page, I get:

Warning: unexpected error in date() in c:\localhost\www\testforum\admin\functions.php on line 1738

[sabret00the]

in your query try inserting is as
[sql]
time = '".NOW()."'");[/sql]

[assassingod]

Doesn't work. (Don't think that's even a function)

[sabret00the]

yeah it is

how are you trying to enter it into the database

it depends on what information you're trying to enter really

if you want the time as well as the date and what not. although to enter is into the db you should have to concatenate is as above.

[assassingod]

I've got it now thanks. I made an error when writing my create table query. (And I get undefined function error with now, so i' used time)

Thanks anyways sabe

[sabret00the]

sorry i weren't more intelligent

[Dean C]

I normally use a mysql field called timestamp - so then i don't have to worry about it all as mysql does it automatically

[assassingod]

I was originally using timestamp(14) but chaning to int(10) UNSIGNED, it worked fine

[NTLDR]

Originally Posted by sabret00the

in your query try inserting is as
[sql]
time = '".NOW()."'");[/sql]

Your almost right:

[sql]time = NOW()[/sql]

Should work, as should:

PHP Code:

time = ".time()." 


or

PHP Code:

time = $timenow 


[assassingod]

yeah ive used time() now.