DB structure question

[micmac]

Hi all,
I'm creating a hobby site....movie titles, reviews, info etc.
What i am wanting to know is what would be the best way to set up the relationships btween the tables within the mySQL DB?
ie. if i had a table called 'movies' with fields called 'movie_id','title','genre' and 'rating' how can i relate this to my 'actors' table. Obviously there would be actors that appear in more than one movie. Basically i don't want to repeat the entries.
The same would apply to a 'directors' table.

Any ideas on a good DB structure?

Cheers,
micmac

[pyfsapple]

Obviously, the most convenient and fastest way is to create another table.

For example:

TABLE "movie_actor"
Column "movie_id", "actor_id"

This will keep the entries which make further retrieval of data easier, and as an advance, you can add more columns like "character_name".