time-stamp

[vijukumar]

hi all...

this is my Table

CREATE TABLE `client` (
`client_id` tinyint(4) unsigned NOT NULL auto_increment,
`client_name` varchar(255) NOT NULL,
`client_email` varchar(255) NOT NULL,
`client_phone` int(20) unsigned NOT NULL,
`client_mobile` int(20) unsigned NOT NULL,
`client_country` varchar(255) NOT NULL,
`c_billing_address` text NOT NULL,
`modified_date` int(11) NOT NULL,
`edited_date` int(11) NOT NULL,
PRIMARY KEY (`client_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

`modified_date` int(11) NOT NULL,
`edited_date` int(11) NOT NULL, in that these two fields are to store the values whenever person changes or alter to this form.... so can you please tell how to make these fields to store the time of modified and altered tines in those fields? should i change the type(int(11))?

form contains input fields for only

`client_name` varchar(255) NOT NULL,
`client_email` varchar(255) NOT NULL,
`client_phone` int(20) unsigned NOT NULL,
`client_mobile` int(20) unsigned NOT NULL,
`client_country` varchar(255) NOT NULL,
`c_billing_address` text NOT NULL,

this one auto increment
`client_id` tinyint(4) unsigned NOT NULL auto_increment,

please give me the full code if i have to make any changes in the php file...

[vijukumar]

whenever i fill the data and save this form all datas will be store in database only except for
`modified_date` int(11) NOT NULL,
`edited_date` int(11) NOT NULL,

those fields will be store as zeros.
please tell me what should i do?

how to make them to store the current modified date and edited date whenever the person changes it?
thank you.

[ryan_vietnow]

change the datatype of these 2 to date or timestamp.

[vijukumar]

in addition please pass me the sample code where these time stamps are explained bit so that let this kid to learn more...

[vijukumar]

hi ryan,

please tell me is possible to retaining it as int only and to store its time in database?

i have been told by others that if i use it as date or time-stamp type it will be trouble some to use it in later part

will you pass me any simple php code where there ideas are used?
thanks a lot for your reply.

[ryan_vietnow]

could you please post your code?...