[SOLVED] how to enter current datetime

[dadamssg]

im trying to make a column that has the current datetime the row was created...this isn't working, any help would be greatly appreciated

 

$today = time();

$cxn = mysqli_connect($host,$user,$passwd,$dbname)
         or die("Couldn't connect"); 

$sql = "INSERT INTO test (title, description,location, event, created, start, end, createdby)
VALUES ('{$_SESSION['title']}','{$_SESSION['description']}','{$_SESSION['location']}'
         ,'{$_SESSION['event']}','{$today}', '{$_SESSION['starts']}', '{$_SESSION['ends']}', '{$_SESSION['logname']}')";

[fenway]

DON'T mark topics "solved" unless you post the solution...

[dadamssg]

sorry :/

 

$today = date("Y-m-d H:i:s");

$cxn = mysqli_connect($host,$user,$passwd,$dbname)
         or die("Couldn't connect"); 

$sql = "INSERT INTO test (title, description,location, event, created, start, end, createdby)
VALUES ('{$_SESSION['title']}','{$_SESSION['description']}','{$_SESSION['location']}'
         ,'{$_SESSION['event']}','{$today}', '{$_SESSION['starts']}', '{$_SESSION['ends']}', '{$_SESSION['logname']}')";