这是我的 SQL 小提琴：SQL小提琴 http://rextester.com/GERD25923
我正在尝试使用 PHP 来回显这个结果。这是我的预期结果：
// Some Stuff Here
The Dark Knight Rises - 7.5
Batman Begins - 7.5
Iron Man - 7.3
The Lord of the Rings: The Return of the King - 8.1
etc...
// Some more Stuff here
我的 PHP 代码：
$stmt = $conn->prepare("SELECT tmdb_movies.movie_title
,GROUP_CONCAT(recommendations.recommendations_title ORDER BY recommendations.recommendations_title) as recommendations_title
,GROUP_CONCAT(recommendations.recommendations_vote_average ORDER BY recommendations.recommendations_title) as recommendations_vote_average
FROM tmdb_movies
LEFT JOIN cast ON cast.cast_tmdb_id=tmdb_movies.tmdb_id
LEFT JOIN recommendations ON recommendations.recommendations_tmdb_id=tmdb_movies.tmdb_id
Where tmdb_movies.tmdb_id= 155
GROUP BY tmdb_movies.movie_title
");
// Then fire it up
$stmt->execute();
// Pick up the result as an array
$result = $stmt->fetchAll();
// Now you run through this array in many ways, for example
for($x=0, $n=count($result); $x < $n; $x++){
$recommendations_name_list = explode(',',$result[$x]["recommendations_title"]);
$recommendations_vote_average = explode(',',$result[$x]["recommendations_vote_average"]);
foreach( $recommendations_name_list as $index => $recommendations_title ) {
echo'
<p>'.$recommendations_title.'- '.$recommendations_vote_average[$index].'</p>';
}
}
Output of this code:
Batman Begins- 7.5
Batman Begins- 7.5
Batman Begins- 7.5
Batman Begins- 7.5
Batman Begins- 7.5
Batman Begins- 7.5
Batman Begins- 7.5
Batman Begins- 7.5
Batman Begins- 7.5
Batman Begins- 7.5
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Captain America: The First Avenger- 6.6
Inception- 8
Inception- 8
Inception- 8
Inception- 8
Inception- 8
Inception- 8
Inception- 8
Inception- 8
Inception- 8
Inception- 8
Iron Man- 7.3
Iron Man- 7.3
Iron Man- 7.3
Iron Man- 7.3
Iron Man- 7.3
Iron Man- 7.3
Iron Man- 7.3
Iron Man- 7.3
Iron Man- 7.3
Iron Man- 7.3
Iron Man 2- 6.6
Iron Man 2- 6.6
Iron Man 2- 6.6
Iron Man 2- 6.6
Iron Man 2- 6.6
Iron Man 2- 6.6
Iron Man 2- 6.6
Iron Man 2- 6.6
Iron Man 2- 6.6
Iron Man 2- 6.6
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Dark Knight Rises- 7.5
The Lord of th- 8
但是如果我删除这一行LEFT JOIN cast ON cast.cast_tmdb_id=tmdb_movies.tmdb_id
然后，我的 php 代码工作正常。
预期结果：
Batman Begins- 7.5
Captain America: The First Avenger- 6.6
Inception- 8
Iron Man- 7.3
Iron Man 2- 6.6
The Dark Knight Rises- 7.5
The Lord of the Rings: The Fellowship of the Ring- 8
The Lord of the Rings: The Return of the King- 8.1
The Lord of the Rings: The Two Towers- 7.9
The Matrix- 7.9
