How to display mysql table using for loop in php

//please dont forget to connect to mysql
$objDB = mysql_select_db('my_db');
$qry_acct='SELECT * From My_test_table';
$result_acct=mysql_query($qry_acct) or die ('Error Query ['.$qry_acct.']');
$num_acct = mysql_num_rows($result_acct);
for($i=0;$i<s $num_acct;$i++)
{
//My Column is one of the column in my TABLE
echo mysql_result($result_acct,$i,'My Column').'<br>';
}

$servername = "localhost";
$username = "";
$password = "";
$db="";
$tablename="";
$conn = mysqli_connect($servername, $username, $password, $db);
$qry = "SELECT * FROM $tablename";
$result = mysqli_query($conn,$qry);
$num_acct = mysqli_num_rows($result);
for($i=0;$i<$num_acct;$i++)
{
$data= mysqli_fetch_row($result);
echo $data[$i]."<br>";
}