mysql-2

<?php

$con=new mysqli ("localhost","root","","student");

$sql = "SELECT id,s_name FROM admission";

$result = $con->query($sql);

echo "<table border='1'>";

          echo "<tr><th>id</th><th>Name</td></tr>";

                   echo "</table>";

if($result->num_rows >0)

{

while($row= $result->fetch_assoc())

{

                             echo "<table border='1'>";

                   echo "<tr><td>".$row["id"]."</td></u>";

            echo "<td>".$row["s_name"]."</td></tr>";

            echo "</table>";

}}

else

{

          echo 0;

}

?>

OR

<?php

$con=new mysqli ("localhost","root","","student");

$sql = "SELECT id,s_name FROM admission";

$result = $con->query($sql);

if($result->num_rows >0)

{

          echo "<table border='1'>";

          echo "<tr><th>id</th><th>Name</td></tr>";

          echo "</table>";

}

while($row= $result->fetch_assoc())

{

                   echo "<table border='1'>";

                   echo "<tr><td>".$row["id"]."</td></u>";

            echo "<td>".$row["s_name"]."</td></tr>";

            echo "</table>";

}

?>