<?php 
$username="root";  
$password="";  
$hostname = "localhost";  

$dbhandle = mysqli_connect($hostname, $username, $password)  
or die("Unable to connect to MySQL");  
echo " ";  

$selected = mysqli_select_db($dbhandle, "test")  
or die("Could not select examples");  
   
$result = mysqli_query($dbhandle,"SELECT * FROM `organization_of_sports_events`");
$result2 = mysqli_query($dbhandle,"SELECT * FROM `organization_of_sport_events_2018_19`");
$result3 = mysqli_query($dbhandle,"SELECT * FROM `participation _2018_2019`");



?>
<!DOCTYPE html>


<html>
    <head>
        <link rel="stylesheet" type="text/css" href="db.css">
    </head>
    <body>
    <table align=center border="1px solid #0b0b0b" style=" ">
                            <tr>
                                <th colspan="">Tornament Name </th>
                                <th colspan="">Date </th>
                                <th colspan="">Venue </th>
                                <th colspan="">Rank </th>
                            </tr>

                            <?php 
        while($rows=mysqli_fetch_assoc($result3))
        {
            ?>
                            <tr>
                                <td><?php echo $rows['Name of event'] ?> </td>
                                <td><?php echo $rows['Date'] ?> </td>
                                <td><?php echo $rows['Venue'] ?> </td>
                                <td><?php echo $rows['Result'] ?> </td>



                            </tr>
                            <?php
        }
    ?>

                        </table>
    
    </body>
    
    
</html>