To generate somer report data I want to execute a short sql command to collect some data and hand it over as array to the html->table helper to be displayed.
sql code is SELECT BP.AnreiseDatum, BP.AbreiseDatum, BS.name, LS.Zimmernummer, concat(CS.name,': ',CS.Firma,': ', CS.Vorname,', ', CS.Nachname) FROM `booking_positions` as BP, `bookings` as BS , lodgings as LS, customers as CS WHERE bs.id = bp.`booking_id` AND `lodging_id`=LS.id AND `customer_id`=CS.id is there a better way to solve this using the find()? How do I need to do the views manually (as the bake shell will not be of use as far as I understood...) Thanks in advance Michael 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
