[SOLVED] timestamp

[atticus]

Hi all, I am trying to get a timestamp onto records as they are submitted into the mysql database.  I have field in mysql that is "timestamp" called time.

 

this is a portion of the php code I am using.  I don't think I am using the date() function correctly.  It doesn't error out but the timestamp in the database is all 0's.

 

$stamp = $date(Y-m-d,H-i-s);

 

I did not put this into the form, but created the variable after the form is submitted so the variable can go directly into the database.

[revraz]

Do you want date and time or just time?

 

You can use the mysql NOW() function if you want date and time.

[atticus]

I want date and time, or at least date.

[atticus]

alright, I added it into my query, but still getting same results:

 

$query = "INSERT INTO `order` (type_service, notes, agree, time) 
VALUES ( '$type_service', '$notes', '$agree','NOW()');"; 

[freebsdntu]

$query = "INSERT INTO `order` (type_service, notes, agree, time) 
VALUES ( '$type_service', '$notes', '$agree','NOW()');"; 

 

Hi, try this,remove the ' ' surrounding NOW():

 

$query = "INSERT INTO `order` (type_service, notes, agree, time) 
VALUES ( '$type_service', '$notes', '$agree',NOW());"; 

[atticus]

you are a genius...thanks

[freebsdntu]

you are a genius...thanks

LOL, you are over-praising me, I am just a php starter.

[PHPNewbie55]

Why wouldn't you just create a TIMESTAMP in the MySQL Database..???

Then you wouldn't have to include it in the script like this..

<?php
$query = "INSERT INTO `order` (type_service, notes, agree, time) 
VALUES ( '$type_service', '$notes', '$agree','NOW()');";
?>

 

You could just do this::

<?php
$query = "INSERT INTO `order` (type_service, notes, agree) 
VALUES ( '$type_service', '$notes', '$agree' );";
?>

 

And the NOW() would be taken care oif by the MySQL Column for each record...

 

Just a thought.......