For your information, your database tables does not comply with the CakePHP conventions!
"Join tables, used in hasAndBelongsToMany (HABTM) relationships between models should be named after the model tables they will join in alphabetical order (apples_zebras rather than zebras_apples)" Thus your tables "tag_images" should be "images_tags", and "image_students" should be "images_students". Enjoy, John On May 17, 12:22 pm, John Andersen <[email protected]> wrote: > Your SQL statement has an error in: > > INNER JOIN tags ON tag_images.id = tags.id > > Change to: > > INNER JOIN tags ON tag_images.tag_id = tags.id > > But how is your CakePHP find statement looking like?? That I would > much better like to see! > > Enjoy, > John > > On May 17, 12:16 pm, Dilip Godhani <[email protected]> wrote: > > > > > its not give me right output...! > [snip] 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
