Искам да сравня movie_director = people_id и movie_leadactor = people_id така че да ми ги покаже в таблица по следния ред Име на филма, актьор, режисьор. Има ли как да стане това с 1 запитване. С този скрипт с 2 запитвания ги вадя, но $value1 ми вади 2воен резултат.
Код:
<?php
$host "";
$user "";
$pass "";
$connect = mysql_connect($host, $user, $pass) or die ("Връзката неможе да бъде осъществена");
mysql_select_db("moviesite");
$query = "SELECT movie_name, people_fullname FROM movie LEFT JOIN people " .
"ON movie_director = people_id " .
"WHERE movie_year>1990 " .
"ORDER BY movie_name";
$query1 = "SELECT people_fullname FROM people LEFT JOIN movie " .
"ON movie_leadactor = people_id " .
"WHERE movie_year>1990 " .
"ORDER BY movie_name";
$results = mysql_query($query) or die (mysql_error());
$results1 = mysql_query($query1) or die (mysql_error());
echo "<table border =\"1\">\n";
while
(($row = mysql_fetch_assoc($results)) and ($row1 = mysql_fetch_assoc($results1))) {
echo "<tr>\n";
foreach($row as $value ) foreach($row1 as $value1) {
echo "<td>\n";
echo $value;
echo "</td>\n";
echo "<td>\n";
echo $value1;
echo "</td>\n";
}
echo "</tr>\n";
}
echo "</table>\n";
?>