Php Mysql output actors from db. Kinopoisk?

Question

PHP

Hello guys, tell me how to display actors from the database by id if there are 2 million records in the database? And how film search so displays actors, directors and screenwriters, for example, and shares. I think it can be solved like this, output
SELECT * FROM actors
We have an array of data and what to do next? If foreach does not perceive, it requires a lot of RAM and this is unrealistic. I can just imagine, but I can't figure out how.
In the database, for example, the film directors are stored like this, as 1,2,3,4,5,6well as actors and screenwriters. How to solve, please help?

Answer 1

You need a separate, linking, table, which will have a field pointing to the director's id from the directors table and the movie id from the movies table.
You just store the directors incorrectly (if I understand correctly, you store them separated by commas in one of the fields)

Answer 2

First, learn MySql. If you are not interested, hire someone who understands this. A question the answer.
If you want to get a normal answer, specify the structure of the table or database, give more data

Answer 3

That is, if I understand correctly, it should look like this, creating a new table, for example

<b>old_actors</b>
Структура будет такой id, actors_id, types
id - уникальный ид
actors_id - id актера, режисера, сценариста и тд...
types - id кто такой то есть, directors, actors или scenaryo