Search the Community
Showing results for tags 'date_created'.
Sorry, I have to ask this but I have not been able to find a solution via Google search for something that should be simple!! My usertype table has a date_created field similar to your customer table and I want to update this field via PHP. I searched the code I downloaded and can not seem to find where you updated this field. Modifying your example, I have created a table, usertype, that has the field modifedDate defined as: 'modifiedDate' timestamp Not Null Default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP. In my insert code, I have the following code (in CodeIgniter): $data = array('userType' => $this->input->post('dusertype'), 'modifiedBy => "Admin', 'modifiedDate => date('d-m-Y H:i:s'); $this->db->insert(usertype, $data); The MySQL table fields, usertypeID, userType, modifiedBy are all inserted properly. The data field, modifiedDate, is formatted as 0000-00-00 00:00:00 even if I try Date() or Now(). What am I doing wrong, it seem that it should be so simple?? Thanks. John K