Login

01-28-2009, 08:18 PM

[eluser]plasmagames[/eluser]
ok, i have gotten to the comments part where it displays them. So far the script will submit the comments but won't display them.

Heres what the browser gives me

Quote:Fatal error: Call to a member function num_rows() on a non-object in /home/pmgames/public_html/code/system/application/views/newscomment.php on line 16

Here's the Code for the comment view file

Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

&lt;html &gt;

&lt;head&gt;

&lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt;

&lt;title&gt;&lt;?=$title?&gt;&lt;/title&gt;

&lt;link href="http://plasmasteelgames.net/code/assets/psgv.css" rel="stylesheet" type="text/css"&gt;

&lt;/head&gt;

&lt;body&gt;

<center>

<h1>&lt;?=$heading?&gt;</h1>

</center>

<hr />

    &lt;?php if ($query->num_rows() > 0): ?&gt;

    &lt;?php foreach($query as $row): ?&gt;

    <h5>&lt;?= $row->author; ?&gt;</h5>

    <hr />

    <p>&lt;?= auto_typography( $row->body); ?&gt;</p>

    <br />

    <hr />

    &lt;?php endforeach; ?&gt;

    &lt;?php endif; ?&gt;

<hr />

<p>&lt;?=anchor('news/comments/'.$row->id, 'Comment');?&gt;</p>

&lt;?=form_open('news/comment_insert');?&gt;

&lt;?=form_hidden('entry_id', $this->uri->segment(3));?&gt;

<p><b>Comment</b></p>

<p>&lt;textarea name="body" rows"10" cols="50" rows="10"&gt;&lt;/textarea></p>

<p>Author:</p><p>&lt;input type="text" /&gt;&lt;/p>

<p>&lt;input type="submit" value="Add Comment" /&gt;&lt;/p>

&lt;/form&gt;

&lt;/body&gt;

&lt;/html&gt;

and heres the controller

Code:
&lt;?php

class News extends Controller {

    function News()

    {

        parent::Controller();

            */the Database Connection Info\*

            $this->load->database($config);

            $this->load->scaffolding('news');

            $this->load->helper('typography');

            $this->load->helper('form');

            $this->load->helper('url');

    }

    function index()

    {

        $data['title'] = "Plasma Steel Games | Bring Out Your Inner Gamer!";

        $data['heading'] = "Plasma Steel Games";

        $data['slogan'] = "Bring Out Your Inner Gamer!";

        $data['query'] = $this->db->query('SELECT * FROM news')->result();

        $this->load->view('index.php', $data);

    }

    function comments()

    {

        $data['title'] = "Plasma Steel Games | News Comments";

        $data['heading'] = "Comment Title";

        $this->db->where('entry_id', $this->uri->segment(3));

        $data['query'] = $this->db->query('SELECT * FROM comments')->result();

        $this->load->view('newscomment.php', $data);

    }

    function comment_insert()

    {

        $data['query'] = $this->db->query('SELECT * FROM comments', $_POST)->result();

        redirect('news/comments/'.$_POST['entry_id']);

    }

}

?&gt;