Re: How do I merge 2 tables
sory my bad.
On Sun, Aug 23, 2009 at 8:08 PM, simplesi wrote:
>
>
>
> Farjad Habib wrote:
> >
> > http://book.cakephp.org/view/78/Associations-Linking-Models-Together
> >
> > go through this and u ll get an idea
> AFAICT there's nothing in there to show how loop through all the records in
> one table and update another table as appropriate :)
>
> I tried modifying the
>
> foreach ($issues as issue) loop in my index view of Issues and I can
> extract
> all associated Change.detail fields using a inner loop of
>
> $totaldetail = '';
> foreach($issue['Change'] as $subchange) {
> if (!empty($subchange['detail'])) {
> $totaldetail = $totaldetail . $subchange['detail'];
> }
> };
>
> but I don't seem able to make Issue.alldetails = $totaldetail and save each
> updated record :(
>
> regards
>
> Simon
>
>
> --
> View this message in context:
> http://www.nabble.com/How-do-I-merge-2-tables-tp25103063p25103642.html
> Sent from the CakePHP mailing list archive at Nabble.com.
>
>
> >
>
--
Farjad Habib
BS 2011
LUMS
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---
Re: How do I merge 2 tables
http://book.cakephp.org/view/78/Associations-Linking-Models-Together go through this and u ll get an idea On Sun, Aug 23, 2009 at 5:55 PM, simplesi wrote: > > > I'm re-coding a simple helpdesk application and I'd like to merge 2 tables > into one. > I could probably do this using a raw MySQL query but I'd like to know if it > is possible to do it using a one-time controller/view action. > > My main table is Issues and my associated table is Changes where each issue > has many changes. > I'd like to loop through each Issue and find all assoicated Change.details > and put them into one Issue.alldetails field. > > Any ideas please? > > regards > > Simon > > > > -- > View this message in context: > http://www.nabble.com/How-do-I-merge-2-tables-tp25103063p25103063.html > Sent from the CakePHP mailing list archive at Nabble.com. > > > > > -- Farjad Habib BS 2011 LUMS --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: HABTM
thanx majna and Martin On Sat, Jul 25, 2009 at 6:45 PM, Martin Kirchgessner wrote: > > If you always want the same Course fields returned by any Student > request, you may also use the "fields" option of the association > definition. > > see http://book.cakephp.org/view/83/hasAndBelongsToMany-HABTM > > > Martin > > On 24 juil, 14:52, Farjad wrote: > > i m defining a habtm relation between students table and courses table > > > > now i want that when i call students to fetch the data particular > > fields of course table are fetched. > > > > currently all the fields of course table are fetched. > > > > can someone help or guide > > > -- Farjad Habib BS 2011 LUMS --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
