function make_related_videos_table($episode) { // two by season, two by category $related_set_season = get_related_videos_by_season($episode["Season"], $episode["EpNum"]); $related_set_category = get_related_videos_by_category($episode["Category1"], $episode["Category2"]); $output = ""; $count = 1; $next_episode = mysqli_fetch_assoc($related_set_season); while ($next_episode && $count <= 2) { $output .= make_episode_cell($next_episode["EpID"]); $count++; $next_episode = mysqli_fetch_assoc($related_set_season); } $count = 1; $same_category_episode = mysqli_fetch_assoc($related_set_category); while ($same_category_episode && $count <= 2) { $output .= make_episode_cell($same_category_episode["EpID"]); $count++; $same_category_episode = mysqli_fetch_assoc($related_set_category); } return $output; }
die("Value not found. "); } else { $total_episodes = mysqli_num_rows($episode_set); $pages = (int) ceil($total_episodes / $episodes_per_page); } $table = ""; if ($total_episodes == 0) { $table .= "No episodes found. "; } for ($page = 1; $page <= $pages; $page++) { $table .= "<script>console.log(\"pages:" . $pages . "\");</script>"; $table .= "<script>console.log(\"total_episodes:" . $total_episodes . "\");</script>"; $table .= "<script>console.log(\"total_episodes / episodes_per_page:" . $total_episodes / $episodes_per_page . "\");</script>"; $episode = mysqli_fetch_assoc($episode_set); /* sometimes this thing will say it has more rows than there are acutally episodes, this is coming from sql. I do this check here to stop the program from generating an unecesary page. */ if ($episode) { $table .= "<ul class=\"medium-block-grid-4 episode_search_result_table\" id=\"episode_result_page_" . $page . "\""; $table .= ">"; $count = 1; while ($episode && $count <= $episodes_per_page) { $table .= make_episode_cell($episode["EpID"]); $count++; $episode = mysqli_fetch_assoc($episode_set); } $table .= "</ul>"; } } mysqli_free_result($episode_set); echo $table;