Login

02-26-2008, 09:03 AM

[eluser]coldKingdom[/eluser]
Now i have done a complete fresh installation of 1.6.1 with no addons or anything activated besides the database library and on a different server.

welcome.php - Controller

Code:
&lt;?php

class Welcome extends Controller {

    function Welcome()

    {

        parent::Controller();    

    }

    function index()

    {

        $this->load->model('Gallery');

        $data['query'] = $this->Gallery->get_last_ten_entries();

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

    }

}

?&gt;

Gallery.php - Model

Code:
&lt;?php

class Gallery extends Model {

    function Gallery()

    {

        // Call the Model constructor

        parent::Model();

    }

    function get_last_ten_entries()

    {

        $this->db->select("gallery_picture");

        $this->db->from('tbl_gallery');

        $total = $this->db->count_all_results(); //Without this it works perfectly

        $query = $this->db->get();

        return $query->result();

    }

}

?&gt;

welcome.php - View

Code:
&lt;html&gt;

&lt;head&gt;

&lt;title&gt;Welcome to CodeIgniter&lt;/title&gt;

&lt;/head&gt;

&lt;body&gt;

&lt;?php

    foreach($query as $item):

        print $item->gallery_picture.'<br /><br />';

    endforeach;

?&gt;

&lt;/body&gt;

&lt;/html&gt;

Error message from CodeIgniter 1.6.1

Quote:An Error Was Encountered
Error Number: 1096

No tables used

SELECT *

I don't know really what more i can do to make it easier. I can test 1.6.0 if you wan't me to.

Edit: Just tested 1.6.0 with the same error