next_game_test.php

<?php
define('DIR', $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR);
define('DB_CLS', DIR . 'admin/class/db.cls.php');

require DB_CLS;

$db = new DB_Connect(MYSQL_INTRANET, 1);
if (!$db) die("Can't connect to database.");

extract($_REQUEST);

$d = array();

$sql = "select a.id, a.game_time, 
concat((select mini_logo from bhleague.teams b where a.team1 = b.id), ' vs ', (select mini_logo from bhleague.teams b where a.team2 = b.id)) as playing, 
a.game_date 
from bhleague.`schedule` a 
where game_date = (select game_date from bhleague.`schedule` where game_date >= now() group by game_date limit 1);";

if ($rs = $db->query($sql)) {
	$rs_cnt = $rs->num_rows;
	if ($rs_cnt > 0) {
		while ($row = $rs->fetch_object()) {
			$playing = $row->playing;
			$game_time = $row->game_time;
			
			$d[] = "['{$playing}', '{$game_time}']";
		}
	}
}

$data = implode(', ', $d);
echo "[ {$data} ]";

$db->close();
$db = NULL;