Hi, Andy Dawson, i'm having a similar problem, but i don't understand your fix.
On 8/16/10, AD7six <andydawso...@gmail.com> wrote: > > > > On Aug 16, 4:27 pm, Abraham Boray <abrahambo...@gmail.com> wrote: > > Guys I'm lost, in the middle of a project I have to separate between > > two pictures form > > 1- Pictures 4 the iPhone > > 2- Pictures 4 the Web > > > > I get this array from the controller by callin : > > $this->Picture->recursive = 0; > > $this->set('pictures', $this->paginate()); > > > > the array is a set of pictures and the GAME (to which they belong) > > And every game have a CATEGORY > > > > Array > > ( > > [0] => Array > > ( > > [Picture] => Array > > ( > > [id] => 1 > > [name] => Image_15.png > > [type] => image/png > > [size] => 328004 > > [filesize] => 320 KB > > [ext] => png > > [group] => image > > [path] => /files/iPhone/Image_15.png > > [created] => 2010-08-02 16:19:33 > > [modified] => 2010-08-02 16:19:33 > > [type_id] => 30 > > ) > > ) > > > > [Game] => Array > > ( > > [0] => Array > > ( > > [id] => 9 > > [game_name] => Game2 > > [GamesPicture] => Array > > ( > > [id] => 43 > > [game_id] => 9 > > [picture_id] => 24 > > ) > > > > [Category] => Array > > ( > > [id] => 3 > > [name] => web > > ) > > ) > > ) > > ) > > > > So wot I want is to paginate this including just the web CATEGORY > > PICTURES(Filtring) > > WHERE CATEGORY.nam='web' > > > > I tried this but it'snot working : > > > /////////////////////////////////////////////////////////////////////////// > //////////// > > $this->set('pictures', $this->paginate('conditions' => > > array('Category.name' => 'web'))); > > > > this is the database structure so to get a clearer IDEA. > > > /////////////////////////////////////////////////////////////////////////// > //////////// > > Field TABLE PICTURE > > id > > name > > type > > size > > int(11) > > filesize > > group > > type_id int(11) > > > > Field TABLE GAME > > id > > game_name > > start_date > > end_date > > category_id > > > why not use this field instead of a needless join to your unshown > category TABLE > > yours with a capital word at the end of the LINE > > AD > > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com<cake-php%2bunsubscr...@googlegroups.com>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > -- OKALANY DANIEL, P.O BOX 26150, Kampala., Uganda. http://okasoft.net -- When confronted by our worst nightmares, the choices are few; Fight or flight. We hope to find the strength to stand against our fears but sometimes, despite ourselves, we run. What if the nightmare gives chase? Where can we hide then? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en