mySQL Join

[eluser]R. Oerlemans[/eluser]
Thanks thanks.

Now i'v this:

Code:

$query = $this->db->from('abonnementen')->join('providers', 'providers.id = abonnementen.p_id')->get();
            $array_data = $query->result_array();
            
            /* Page */
                $settingsList = Array(
                    'data' => $array_data
                );

with this in my view

Code:

<?php
    
        foreach($data as $item) ::
        
    ?>

But i get this error, somewhere i've make a mistake but :o

Parse error: syntax error, unexpected T_PAAMAYIM_NEKUDOTAYIM in ****** on line 14