INSERTing time();

[assassingod]

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

time = '".NOW()."'");

[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]

in your query try inserting is as

time = '".NOW()."'");

Your almost right:

time = NOW()

Should work, as should:

time = ".time()."

or

time = $timenow

[assassingod]

yeah ive used time() now.

[FleaBag]

Hmm this is what I need too.

Though I am very confused LOL.

[FleaBag]

Got it sorted, seems inserting now(); into a tinytext field is the easiest option - at least for me!