[RESOLVED] Get the time()

[mikawhat]

I'm using time() to get the time and store it in a database, however the value stored in the db is 838:59:59 . Why is displayed like that? is the function i'm using correct?

Here's my code:

$time = time();
$query = @mysql_query("INSERT INTO useronline (time, ip, file, username) VALUES ('$time','$REMOTE_ADDR','$PHP_SELF', '$row[2]')");

[bogu]

U should use it like this:

$query = @mysql_query("INSERT INTO useronline (time, ip, file, username) VALUES (CURTIME() ,'$REMOTE_ADDR','$PHP_SELF', '$row[2]')"); 

Mysql date and time functions

[mikawhat]

thanks!