You have an error in your SQL, Nie wiem jak uzyskać zapytanie z dwóch tabel Opcje

[saperek25]

oto kod z poziomu php:

[PHP] pobierz, plaintext 
<?php
	//połaczenie z serwerem MySQL
	$connect = mysql_connect("localhost", "root", "karolinka") or die("Sprawdź połaczenie z serwerem");
 
	//uaktywniamy odpowiednią bazę danych
	mysql_select_db("moviesite");
 
	$query = "SELECT movie.movie_name, movietype.movietype_label
				FORM movie, movietype
				WHERE movie.movie_type = movietype.movietype_id
				AND movie.movie_year>1990
				ORDER BY movie_TYPE";
	$results = mysql_query($query) or die(mysql_error());
 
	echo "<table border=\"1\">\n";
	while($row = mysql_fetch_assoc($results))
	{
		echo "<tr>\n";
		foreach($row as $value)
		{
			echo "<td>\n";
			echo $value;
			echo "<td>\n";
		}
		echo "</tr>\n";
	}
	echo "</table>\n";
?>
[PHP] pobierz, plaintext 

i błąd

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'movie, movietype WHERE movie.movie_type = movietype.movietype_id AND m' at line 2
chyba chodzi o kropki :

[SQL] pobierz, plaintext 
SELECT movie.movie_name, movietype.movietype_label
[SQL] pobierz, plaintext