0) { list($code, $name, $mapExpireTime) = mysql_fetch_row($result); $map = new map($code, $mapID); $map->name = $name; $map->dateExpires = strtotime($mapExpireTime); return $map; } } function getMapIDsByDate($date) { global $mysqli; $sql = "SELECT MIN(mapOfTheDay.mapId) AS mapId FROM `mapOfTheDay` INNER JOIN ( SELECT mapType, MIN(mapExpireTime) AS mapExpireTime FROM mapOfTheDay WHERE mapExpireTime > ? AND mapDate <= ? GROUP BY mapType ) AS expireTimes ON mapOfTheDay.mapType = expireTimes.mapType AND mapOfTheDay.mapExpireTime = expireTimes.mapExpireTime GROUP BY mapOfTheDay.mapType"; $stmt = $mysqli->prepare($sql); $stmt->bind_param("ss", $date, $date); $stmt->execute(); $stmt->bind_result($mapID); while ($stmt->fetch()) { $ids[] = $mapID; } return $ids; } ?>