jfkirkpatrick Posted November 16, 2014 Share Posted November 16, 2014 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 Link to comment Share on other sites More sharing options...
jfkirkpatrick Posted November 17, 2014 Author Share Posted November 17, 2014 Larry, Persistence wins out!! I was changing the Update function not the Insert function!! date('Y-m-d H:i:s') worked. Now on to the next challenge!! John K Link to comment Share on other sites More sharing options...
Larry Posted November 21, 2014 Share Posted November 21, 2014 Ah...excellent. Kudos for figuring it out and thanks for letting us know! Link to comment Share on other sites More sharing options...
Recommended Posts