Hi, I'm pretty new to the forums, lurked around, but I fell on a problem on my website, using PHP and MySQL, most of the things works, but I don't quite understand the Join method correctly in MySQL.
What I'm trying to do is match an 'id' with its respectful category name.
First I have my 'categories' table that uses an 'id' and a 'name' row.
Then I have my 'movies' table that has number of plays, etc, but the most important, a row called 'category' with the actual category id assigned to it.
To print the category id, I have no problems - $row['category']
But I need to print the category name, and I guess the easiest way is with the Join method.
Anyone can help me out? Since I don't understand it at all.
Thanks a bunch!

