The Simplest Way to Retrieving Query Result

require_once(‘mysqli_connect.php’);

$q = “SELECT id AS id, title AS title, duration AS duration FROM movies”;
$r = @mysqli_query($dbc, $q);

if($r){
echo ‘

‘;

while ($row = mysqli_fetch_array($r,MYSQLI_ASSOC)) {
$bg = ‘#eeeeee’;
$bg = ($bg==’#eeeeee’ ? ‘#ffffff’ :’#eeeeee’); // Switch the background color.
echo ‘

‘;
}
echo ‘

ID	Title	Duration
‘ . $row['id']. ‘	‘ . $row['title'] . ‘	‘ . $row['duration'] . ‘

‘;

mysqli_free_result ($r);