MySql Date HELL!!!

[eluser]Unknown[/eluser]
Good evening!

I've the spent the better part of today - in between episodes of "The Office" - figuring out how to get MySql to auto insert a date into my blog and my comments. I've read several other posts and tried several techniques to no avail. With the exception of a CSS sheet and some minor styling, the documents are exactly like the video tutorials. Can someone please show me how to fix this? Any help would be greatly appreciated.

This is what I have:

blog.php file

Code:

<?php

class Blog extends Controller {

    function Blog()
    {
        parent::Controller();
        
        $this->load->scaffolding('entries');
        
        $this->load->helper('url');
        $this->load->helper('form');

    }

    function index()
    {
        $data['title'] = "This is my title";
        $data['heading'] = "This is my heading";
        $data['query'] = $this->db->get('entries');
        
        $this->load->view('blog_view', $data);
    }
    
    function comments()
    {
        $data['title'] = "My Comment Title";
        $data['heading'] = "My Comment Heading";
        $this->db->where('entry_id', $this->uri->segment(3));
        $data['query'] = $this->db->get('comments');

        $this->load->view('comment_view', $data);
    }
    
    function comment_insert()
    {
        $this->db->insert('comments', $_POST);
        
        redirect('blog/comments/'.$_POST['entry_id']);
    }
}

?>

comment_view.php

Code:

<h1>&lt;?=$heading?&gt;</h1>
    
            &lt;?php if ($query->num_rows() > 0):?&gt;
        
                &lt;?php foreach($query->result() as $row): ?&gt;
    
                <p>&lt;?=$row->body?&gt;</p>
                <p>&lt;?=$row->author?&gt;</p>

                <hr>
    
    
                &lt;?php endforeach; ?&gt;
        
            &lt;?php endif; ?&gt;
    
            <p>&lt;?=anchor('blog', 'Back to Blog');?&gt;</p>
    
            &lt;?=form_open('blog/comment_insert');?&gt;
    
            &lt;?=form_hidden('entry_id', $this->uri->segment(3));?&gt;
    
            <p>&lt;textarea name="body" rows="10"&gt;&lt;/textarea&gt;</p>
            <p>&lt;input type="text" name="author" /&gt;</p>
            <p>&lt;input type="submit" value="Submit Comment" /&gt;</p>
    
            &lt;/form&gt;

blog_view.php

Code:

<h1>&lt;?=$heading?&gt;</h1>
    
            &lt;?php foreach($query->result() as $row): ?&gt;
    
            <h2>&lt;?=$row->date?&gt;</h2>
            <h3>&lt;?=$row->title?&gt;</h3>
            <p>&lt;?=$row->body?&gt;</p>
    
            <p>&lt;?=anchor('blog/comments/'.$row->id, 'Comments');?&gt;</p>

            <hr>
    
            &lt;?php endforeach; ?&gt;