[SOLVED] problem with capturing time

[jaydeesmalls]

Hi all,

 

I have this

 

$date=date('Y-m-d');
$time=time('NOW()');

$query="INSERT INTO $tbl_name (date, time, product, phoneline, question, answer, metatags) VALUES ('$date', '$time', '$product', '$phoneline', '$question', '$answer', '$metatags')";
$result=mysql_query($query);

 

And all the fields work except for time.

 

The field type in the table is "TIME", but all I get is 00:00:00.

 

Any suggestions? 

 

Thank you

[trq]

Firstly, your passing an arument to time, it doesn't except any. Secondly, time returns a unix tiestamp so you'll need to change your mysql field type accordingly.

[jaydeesmalls]

thank you Thorpe.

 

Unfortunately, I've very much new to this, and don't fully understand.  Would you (or someone else) mind to further explain.

 

Thank you

[jaydeesmalls]

I googled what you put in, and figured it out. 

 

Thank you Thorpe!