Getting a photo of inside an Album for icon

[eluser]JamieBarton[/eluser]
Wow, what a genius.

I haven't tried it out yet.

My tables are:

Albums:
album_id
album_name
user_id (for who uploaded album)

Photos:
photo_id
album_id
name
file_path
uploaded


I want to only show albums by that user ( user_id of the album).

My model

Code:

function get_my_albums(){
    //    $this->db->where('user_id', $this->user_id);
            
        $sql = 'SELECT albums, photos.pfile_name MAX(photos.puploaded) as uploaded FROM albums as album LEFT JOIN photos as photo ON (photos.album_id = album.album_id) GROUP BY album.album_id';
            
        $this->db->query($sql);
            return $this->db->get($this->table_name);
    }