Untitled

<html>
    <head>
        <title>TEAM SELECTION</title>
         <link href="showCountryPlayer.css" rel="stylesheet" type="text/css">
        <?php include_once"jquery.php"?>

    </head>
    <body>
        <form >
            <select name="country" id="cn">
                <option value="bangladesh">Bangladesh</option>
               <option value="india">India</option>
               <option value="pakistan">Pakistan</option>
               <option value="australia">Australia</option>
               <option value="westIndies">WestIndies</option>
               <option value="southAfrica">SouthAfrica</option>
               <option value="england">England</option>
               <option value="newzealand">NewZealand</option>
               <option value="srilanka">Srilanka</option>
               <option value="afganistan">Afganistan</option>
           </select>
             <select name ="category" id="cat">
                <option value="all-rounder">all-rounder</option>
                <option value="batsman">batsman</option>
                <option value="bowler">bowler</option>
            </select>
            <input type="SUBMIT" value="Submit" id ="submit">
        </form>
        <div id="t1"></div>
        <script>
           $("form").submit(
               function(){
                   var cn=$("#cn").val();
                   var cat=$("#cat").val();
                    alert(cn);alert(cat);
                    $("#t1").load("show_country_player.php",{"country":cn,"category":cat});
               }
           );
        </script>
    </body>
</html>

<?php
include_once"Database.php";
    $server="localhost"; $db="fantasy cricket";$user="root";$password="a2lrasna";
    $db=new Database($server,$db,$user,$password);
    $cn=$_REQUEST["country"];
    $cat=$_REQUEST["category"];
    $db->showCountryPlayer($cn, $cat);
?>