Hi,
Thanks for your reply.
I cannot change my table structure.. I need to use the existing
table..
regards
Shihab
On Sep 7, 8:55 pm, Phil Moorhouse <moorhouse.p...@gmail.com> wrote:
> Is your schema already fixed?
>
> If not, the normal way to do this would be to have m-m join tables:
>
> NewsImage [ news_id, image_id ]
> EducationImage [ education_id, image_id ]
> HealthImage [ health_id, image_id]
>
> and remove:
> content_id
> type
> from the ContentImage table.
>
> Then if you want all "news" images, something like:
> $q = Doctrine_Query::create()
> ->from('ContentImage ci')
> ->innerJoin('NewsImage');
> $newsImages = $q->execute();
>
> or images for a particular news item:
> $news->getImages();
>
> On 7 Sep, 15:30, Shihab KB <shiha...@gmail.com> wrote:
>
>
>
> > dear friends,
>
> > I have the following tables.
>
> > News [id, title, …]
> > Education [id, title…..]
> > Health [id, title, ….]
> > ContentImage [id, contented (id of the News, Education, Health), type
> > (like News, Education, Health), path…]
>
> > The News, Education, Health may or may not have images in the
> > ContentImage table. There is no relationship is set in between News,
> > Education, Health table with ContentImage table. But we can link the
> > programatically by using id=contentid and type = 'News'. I want to
> > write a Doctrine query the return the left outer join between News,
> > Education, Health tables and ContentImage table.
>
> > Is it possible thru dotrine query?
>
> > Or do I need to write the query like below,
>
> > [code] $sql = "SELECT * FROM... ";
> > $pdo = Doctrine_Manager::connection()->getDbh();
> > $data = $pdo->query($sql)->fetchAll(); [/code]
>
> > Please reply.- Hide quoted text -
>
> - Show quoted text -
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
