films:
id | title | year | description | time | url
genres:
id | title
actors:
id | name | date
связи по id:
films_genres:
id_film | id_genre
films_actors
id_film | id_actor
Есть 3 запроса:
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- films.id,
- films.title,
- films.year,
- films.description
- FROM films
- ORDER BY year DESC LIMIT 6" ,$db);
- actors.name as actor_name
- FROM films,actors WHERE
- actors.id in (SELECT id_actor FROM films_actors WHERE id_film=films.id)" ,$db);
- genres.title as genre
- FROM films,genres WHERE
- genres.id in (SELECT id_genre FROM films_genres WHERE id_film=films.id)" ,$db);