Reply to thread

Message: <blockquote data-quote="Deda" data-source="post: 663239" data-attributes="member: 89768">Ok here's the result of investigation: in table "movieinfo" you need in column"idDirector" to put a record which is related to "actors" table.So in case of "Terminator 2" put 1 ->Unknown in "actors" table. If director exists for movie it should be in "actors" table with it's id and that id must be also in "movieinfo" "idDirector" field for that movie.I hope that this will help you.MP query to get movies and infos is like this:select * from movie,movieinfo,actors,path where movieinfo.idmovie=movie.idmovie and movieinfo.iddirector=actors.idActor and movie.idpath=path.idpath</blockquote>