'; $tStats = getStat(1); $yStats = getStat(2); $wStats = getStat(3); $mStats = getStat(4); function getStat ($type) { switch ($type) { //Todays case 1: $where = " DATE_ADD(CURDATE(), INTERVAL -0 DAY) = DATE_FORMAT(solutions.dateModified,'%Y-%m-%d') AND DATE_ADD(CURDATE(), INTERVAL -0 DAY) = DATE_FORMAT(maps.dateCreated,'%Y-%m-%d') "; $statname = "Today's Best Overall:"; break; //Yesterdays case 2: $where = " DATE_ADD(CURDATE(), INTERVAL -1 DAY) = DATE_FORMAT(solutions.dateModified,'%Y-%m-%d') AND DATE_ADD(CURDATE(), INTERVAL -1 DAY) = DATE_FORMAT(maps.dateCreated,'%Y-%m-%d') "; $statname = "Yesterday's Best Overall:"; break; case 3: $where = " YEARweek(solutions.dateModified) = YEARweek(CURRENT_DATE) "; $statname = "This week, starting Sunday"; break; case 4: $where = " month(solutions.dateModified) = month(CURRENT_DATE) "; $statname = "This month's Best"; break; } $sql = "SELECT users.displayName as Name, SUM(solutions.moves) as Moves, timediff(MAX(dateModified), maps.dateCreated) as Timetaken FROM `maps` JOIN `solutions` ON maps.ID = solutions.mapID JOIN `users` ON solutions.userID = users.ID WHERE $where GROUP BY solutions.userID ORDER BY Moves DESC, MAX(dateModified) ASC "; $result = mysql_query($sql); return displayStats($result, $statname); } ?>

0) { list($bestMoves, $byName, $solution) = mysql_fetch_row($result); //echo "Best solution for this map: $bestMoves by $byName"; //$map = MergeMapSolution($map, $solution); //echo DisplayMap($map, $mapID); } echo '

'; echo "

"; echo '

'; echo $stats; echo '

'; echo '

'; echo "Best solution for this map: $bestMoves by $byName "; echo DisplayMap($map, $mapID, true, 2); echo '

'; echo '

'; } function displaystats($result, $caption = NULL) { //Get names. $headers .= "Rank"; $headers .= "Name"; $headers .= "Moves"; $headers .= "Time taken"; //Start table $r .= ""; $r .= ""; //Headers on the top. including Rank. $r .= ""; $r .= $headers; $r .= ""; $i = 1; while ($row = mysql_fetch_assoc($result)) { $rowcontent = ''; $mapid = $row['mapID']; $solution = $row['solution']; $r .= ""; $r .= ""; $r .= ''; $r .= ''; $r .= ''; $r .= ""; $i++; } $r .= "

$caption
$i	' . $row['Name'] . '	' . $row['Moves'] . '	' . $row['Timetaken'] . '

"; return $r; } function mysql_field_array( $query ) { $field = mysql_num_fields( $query ); for ( $i = 0; $i < $field; $i++ ) { $names[] = mysql_field_name( $query, $i ); } return $names; } // $sql = 'select columnname etc' // $result = mysql_query($sql); // while ($data[] = mysql_fetch_row($result)); // $data[1]['columnname'] == 'my data'; yesterdayMaze(1, 'Easy'); yesterdayMaze(2, 'Normal'); yesterdayMaze(3, 'Complex'); yesterdayMaze(4, 'Special'); ?>