My Database DDL is below
CREATE TABLE `user` (
`token` text NOT NULL,
`country` text NOT NULL,
`timezone` text NOT NULL,
`date_registered` date NOT NULL,
`time_registered` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
How can I make it so that whenever a new record is created that the date and time will automatically be generated and inserted without relying on PHP to add an extra variable for me to process?
http://example.com/webapps/api/add_token.php?token=%@&country=%@&timezone=%@
The @% are variables generated at run time from my iOS application.
Before a row was generating when I ran my application. But I added two new fields (date_registered and time_registered) and now it is not adding data to the table