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 to
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
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: inserting server time into mysql
Thanks for your help,
How can I capture
, 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 your help,
How can I capture this information from a php
Thanks guys,
It worked - thank you all so very much.