Welcome Guest, Not a member yet? Register   Sign In
db->insert Not Working
#1

[eluser]wynnewade[/eluser]
After creating an associative array of values, I am calling $this->db->insert( 'career_jobpostings', $newPost );

This does NOT produce any errors NOR does it produce a new database record.

I am retrieving data from the database so I feel that my database.php is set correctly.

and the ONLY field in the database that I am NOT including in the array is the primary key field which is set to auto-increment. When I dump the array, all values are correct.

I have been at this for hours and cannot find the issue. Please help!

controller code below
----------
$newPost = array(
'postDate' => date( "Y-m-d" ),
'closeDate' => $this->input->post('closeDate'),
'jobTitle' => $this->input->post('jobTitle'),
'jobLocation' => $newJob['jobLocation'],
'jobCity' => $newJob['jobCity'],
'jobState' => $newJob['jobState'],
'positionSummary' => $newJob['positionSummary'],
'positionQualifications' => $newJob['positionQualifications'],
'summarySheet' => 'thisFile.pdf',
'openStatus' => $this->input->post('postStatus'),
'infoURL' => 'http://www.edrtrust.com',
'lastEdited' => date( "Y-m-d h:iConfused" )
);

//echo "<pre>";
//var_dump($newPost);
//echo "</pre>";

$this->db->insert( 'career_jobpostings', $newPost );


Messages In This Thread
db->insert Not Working - by El Forum - 11-02-2010, 05:55 AM
db->insert Not Working - by El Forum - 11-02-2010, 07:12 AM
db->insert Not Working - by El Forum - 11-02-2010, 12:25 PM
db->insert Not Working - by El Forum - 11-02-2010, 05:44 PM
db->insert Not Working - by El Forum - 09-27-2014, 11:00 AM



Theme © iAndrew 2016 - Forum software by © MyBB