I have a MYSQL database that has these tables, type is MYISAM.
Studios (StudioName, StudioID=int)
Genres (GenreName, GenreID=int)
Titles (TitleName, Details, StudioID=int, GenreID=int, TitleID=int)
Actors (ActorName, ActorID=int)
ActorTitle (TitleID=int, ActorID=int)
TitleGenres (TitleID=int, GenreID=int)
This is the SQL statement:
SELECT A.TitleName, C.ActorName
FROM Titles A, ActorTitle B, Actors C
Where
A.TitleID=B.TitleID
AND B.ActorID=C.ActorID
AND A.TitleName LIKE '%something%'
ORDER BY A.TitleName ASC
This gives me a list of the same Titles with an actor next to each of the same title.
How can I make it show up on the website with the Title just once and all the actors?