Login

04-25-2009, 10:00 AM

[eluser]cpeele[/eluser]
Hey guys, I am very new to codeIgniter and am trying to get my page to display some database results but no rows show.

1) I have data in my database

2) I have set autoloading

3) Here is my database configuration:

Code:
$db['default']['hostname'] = "localhost";

$db['default']['username'] = "root";

$db['default']['password'] = "";

$db['default']['database'] = "qno";

$db['default']['dbdriver'] = "mysql";

$db['default']['dbprefix'] = "";

$db['default']['pconnect'] = TRUE;

$db['default']['db_debug'] = TRUE;

$db['default']['cache_on'] = FALSE;

$db['default']['cachedir'] = "";

$db['default']['char_set'] = "utf8";

$db['default']['dbcollat'] = "utf8_general_ci";

4) Here is my Controller

Code:
&lt;?php

class Questions extends Controller

{    

    function index()

    {

        $data['query'] = $this->db->get('questions');

        $this->load->view('questions', $data);

    }

}

?&gt;

5) Here is my view

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

this does not show :(

&lt;?php endif; ?&gt;

<ul>

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

    <li>&lt;?=$row->name?&gt;</li>

&lt;?php endforeach; ?&gt;

</ul>

6) Here is my output when I do a print_r($data);

Code:
Array ( [query] => CI_DB_mysql_result Object ( [conn_id] => Resource id #28 [result_id] => Resource id #29 [result_array] => Array ( ) [result_object] => Array ( ) [current_row] => 0 [num_rows] => 2 [row_data] => ) )

Please if anyone can help me I would really appreciate it. I would like to start using CI over CakePHP but I can't even get this to dispaly database results.

Thanks for any help,

Chris