[darkcarnival]

hi,

im making a forum and i want to store the posted date and time but i do not do both in 1 row. can i add currdate and currtime together?

thx in advance.

[<?Wille?>]

in the forum im doing i store the unix timestamp ( time() ) and then when i display it i use date().. this way you can have the forum to show times in userdefined format and in their own time zone

[darkcarnival]

hmm ok though im confused on how i can convert time() into date().

could you show me?

[Acecool]

date("Properties", time());

[<?Wille?>]

right.. the idea was to insert the timestamp..
$time = time();
insert into table set field="somevalue", dateformat="d m Y", time="$time"

and then when you show it you do
$query
$r = mysql_fetch_array
echo date($r['dateformat'], $r['time'])

awfully shortend and stuff but you get the idea right?
when a user registers he gets to choose how to show the time..

[darkcarnival]

ok cool thx guys