header(); if(isset($_GET['p'])) { $page = $_GET['p']; } else { $page = 1; } $limit = 18; $page -= 1; $offset = $page * $limit; $sql = "SELECT allStar FROM games ORDER BY RAND() LIMIT 1"; $q = $con->prepare(str_replace('allStar', 'name', $sql)); $q->execute(); $random_search_array = $q->fetch(); if($random_search_array || is_array($random_search_array)) { $random_search = array_rand($random_search_array, 1); } ?> <?php echo $pagename; ?> | <?php echo $sitename; ?>

Games

'; } ?>
prepare(str_replace('allStar', 'count(*)', $sql)); $q->execute(); $numberOfGames = $q->fetchColumn(); $q = $con->prepare(str_replace('allStar', '*', $sql)); $q->execute(); if ($numberOfGames >= 1) { $rows = array_slice($q->fetchAll(), $offset, $limit); foreach($rows as $game) { $sql = "SELECT allStar FROM games WHERE id=:id"; $q = $con->prepare(str_replace('allStar', 'count(*)', $sql)); $q->bindParam(':id',$game["id"],PDO::PARAM_INT); $q->execute(); $playingCount = 0; ?> "; } else { echo "



Looks like there are no games, sad.

";} ?>
footer(); ?>