My mysql table strucyure is
Code:
CREATE TABLE `testimonials` (
`testimonial_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(45) NOT NULL,
`address` varchar(45) NOT NULL,
`contact_no` varchar(20) NOT NULL,
`testimonial` text NOT NULL,
`datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` varchar(45) NOT NULL DEFAULT 'awaiting approval',
`read_status` varchar(6) NOT NULL DEFAULT 'unread',
PRIMARY KEY (`testimonial_id`)
) ENGINE=MyISAM
`testimonial_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(45) NOT NULL,
`address` varchar(45) NOT NULL,
`contact_no` varchar(20) NOT NULL,
`testimonial` text NOT NULL,
`datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` varchar(45) NOT NULL DEFAULT 'awaiting approval',
`read_status` varchar(6) NOT NULL DEFAULT 'unread',
PRIMARY KEY (`testimonial_id`)
) ENGINE=MyISAM
all i want is to change my time zone to GMT +05:30 so that the code below saves a timezone specific to my country
Code:
`datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
couldn't find any entry for timezone in phpmyadmin to change timezone.
I am ready to change the table structure to
Code:
`datetime` timestamp NOT NULL,
if anyone can suggest a php code for setting timezone
thanks in advance
[/code]