<?php
if(isset($_POST['submit']))
{
  	if(isset($_GET['go']))
 	{
  		if(preg_match("/^[  a-zA-Z]+/", $_POST['name']))
  		{
			$name			= $_POST['name'];
		    //-query  the database table
		    $sql 			= "SELECT  ID, login, class FROM players WHERE login LIKE '%" . $name .  "%' OR class LIKE '%" . $name ."%'";
		    //-run  the query against the mysql query function
		    $result 		= mysql_query($sql);
		    //-create  while loop and loop through result set
		    while($row 	= mysql_fetch_array($result))
		    {
		          $login  	= $row['login'];
		          $level	= $row['class'];
		          $class	= array(
				  				1 => "Registered", 
		                       	2 => "Clan Member",
		                       	3 => "Moderator",
		                       	4 => "Administrator"); 
		          $ID		= $row['ID'];
		
		if($level == 'Admin')
		{
			$level = $class['4'];
		}
		else
		{
			$level = $class['level'];
		}
	}
}
  //-display the result of the array
  echo "<tr><td>". $ID ."</td><td><a href=\"?p=profile&id=$id\">" .$login . "</a></td><td>". $level ."</td></tr>n";


  }
  }
  else{
  echo  "<tr><td><div id=\"messageBad\">Nothing could be found, Letter not found or search query was empty!</div></td></tr>n";
  }
  
  
?>