form upload question

[eluser]Colin Williams[/eluser]
Wow.

Column count doesn’t match value count at row 1

INSERT INTO entries (title, image, pub_date, body) VALUES (’test work’,NULL, NOW(),’test comments go here’, ‘http://codeigniter.com/’)

Your column count is 4. Your values count is 5. Easy 'nuff.

Also, this mishap can be avoiding by using the Active Record's insert() method rather than writing it out like that. And please don't say you didn't know you could do that. If nothing else, read through the Database Class part of the User Guide. Twice