<?php
$server="localhost";
$user="root";
$pass="";

$connection=mysql_connect($server,$user,$pass) or die("Couldn't connect to DB");
$db=mysql_selectdb("airfix") or die("Wrong or non-existing DB name!");

$servernumber=$_POST["number"];
$code=$_POST["code"];

$what = "SELECT servername FROM servers WHERE servernumber LIKE '$servernumber' LIMIT 1";
$what2 = "SELECT online FROM servers WHERE servernumber LIKE '$servernumber' LIMIT 1";
$what3 = "SELECT maxplayers FROM servers WHERE servernumber LIKE '$servernumber' LIMIT 1";
$what4 = "SELECT players FROM servers WHERE servernumber LIKE '$servernumber' LIMIT 1";
$query = mysql_query($what);
$query2 = mysql_query($what2);
$query3 = mysql_query($what3);
$query4 = mysql_query($what4);
$row = mysql_fetch_object($query);
$row2 = mysql_fetch_object($query2);
$row3 = mysql_fetch_object($query3);
$row4 = mysql_fetch_object($query4);

if($code==1)
{
if($row2->online!="0")
{
 echo $row->servername;
}
else
{
 echo "-1";
}
}
if($code==2)
{
if($row2->online!="0")
{
 echo $row3->maxplayers;
}
}
if($code==3)
{
if($row2->online!="0")
{
 echo $row4->players;
}
}
?>