Thanks guys,
It worked - thank you all so very much.
you have the server's timestamp, not the client's
(timezones are a b**ch sometimes...)
J.R.
-Original Message-
From: Alla-amin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 09, 2006 12:41 PM
To: mysql@lists.mysql.com
Subject: Re: inserting server time into mysql
Thanks for you
null';
then you could just to :
$query = "INSERT INTO staffs (firstname, lastname) VALUES ('$firstname',
'$lastname')";
-Original Message-
From: Alla-amin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 09, 2006 12:41 PM
To: mysql@lists.mysql.com
Subject: Re:
Thanks for your help,
How can I capture this information from a php form into a mysql table.
This is what I did:
1. I created the table and the user to access the database the table is in
create table staffs (
id int not null auto_increment primary key,
firstname varchar(20) not null,
lastname
In the last episode (May 09), Alla-amin said:
> I am trying to capture my server time automatically using php and
> insert it in a mysql table.
>
> Can the timestamp or time data type capture this information
> automatically without having me code anything else?
You can use the 'timestamp' type t
