inserting server time into mysql

2006-05-09 Thread Alla-amin
Hi everyone, 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?

Re: inserting server time into mysql

2006-05-09 Thread Dan Nelson
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

Re: inserting server time into mysql

2006-05-09 Thread Alla-amin
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

RE: inserting server time into mysql

2006-05-09 Thread George Law
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

RE: inserting server time into mysql

2006-05-09 Thread J.R. Bullington
, 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

RE: inserting server time into mysql

2006-05-09 Thread Alla-amin
Thanks guys, It worked - thank you all so very much.