Excellent!  That's exactly what I needed to know!  Thanks a million!

"Justin Patrin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> News.Php.Net wrote:
> > Hi everyone!
> >
> > In trying to learn PHP and MySQL, I'm trying to create a web-based
database
> > application that will keep track of my movies.  I have five tables
(shown in
> > the graphic).  I'm trying to be able to display the results of the
tables
> > with one movie title, all of the actors associated with it, and all of
the
> > genre's associated with it.
> >
> > Of course I can do the query:
> >   Select *
> >   From MovieMain, MovieActor, MovieGenre, Genre, Actors
> >   Where MovieMain.MovieID=MovieGenre.MovieID
> >   And MovieMain.MovieID=MovieActor.MovieID
> >   And MovieActor.ActorID=Actors.ActorID
> >   And MovieGenre.GenreID=Genre.GenreID
> >
> > But that displays the movie title for every genre and actor there is.
Is
> > there another way to perform the query that will display the title once,
and
> > all of the associated genres and all of the associated actors for that
> > movie?  Or should I try to code it using PHP to find the movie title
first?
> >
> > Thanks in advance, everyone!
> >
> >
> >
>
> There's no way to do that in SQL alone. You should do it in PHP. :-)
>
> -- 
> paperCrane <Justin Patrin>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to