<?php
require("functions.php");
$last = $_GET['last'];
$start = $_GET['start'];

if (isset($_GET['size']))
	$size = $_GET['size']+1;
else
	$size = 11; 

$db = my_connect();
$result = $db->query("SELECT id, firstname, lastname FROM Players WHERE lastname like '".$last."%' LIMIT $start , $size");
$player_list  = null;
while ($row = $result->fetch_array(MYSQL_ASSOC)) {
  $player = null;
  foreach ($row as $field) {
	  $player[] = $field;
  }
  $player_list[] = $player;  
}
echo json_encode($player_list);

// Free resultset
$result->close();

// Closing connection
$db->close();
?>