I'm new of fuel, and code igniter too, but I'm quite expert about mysql management, and following your tutorials I'm developing my first CMS as well.
I have a question about the multi list. Following your tutorials http://www.getfuelcms.com/user_guide/modules/tutorial
I'm trying to create a multiple choice select, because I need to add a field to the table models form to allow me to associate one or more songs to a setlist's gig. Your example about "Associating Categories to Articles" fit to me, except that I need to keep the record in the right order.
I get the array from the table with:
$songs_setlist = (!empty($values['id_gig'])) ? ($CI->songs_to_gigs_model->find_all_array_assoc('id_song', array('id_gig' => $values['id_gig']),"")) : array();
In my song_to_gig_model I have a method _common_query like the following:
$this->db->join('tbl_gigs', 'tbl_songs_gigs.id_gig = tbl_gigs.id_gig', 'left');
$this->db->join('tbl_songs', 'tbl_songs_gigs.id_song = tbl_songs.id_song', 'left');
It seems that the songs in my tbl_song_gigs aren't sorted in the right order, which is the field "number_song".
Can you help me with some tips to solve this problem ?