I’m a Right Brainer

The following code demonstrates getting data from MySQL database:

<?php
include 'config.php';
include 'opendb.php';

$query  = "SELECT NoMatriks, Nama, NamaBapa FROM student";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo "No Matriks : {$row['NoMatriks']} <br>" .
         "Nama : {$row['Nama']} <br>" .
         "Nama Bapa : {$row['NamaBapa']} <br><br>";
}

include 'closedb.php';
?>

Source: PHP-MySQL-Tutorial

Method II:

$query="select * from pelajarjmti"; 
$rt=mysql_query($query);         
echo mysql_error();                   

while($nt=mysql_fetch_array($rt)){
echo "$nt[NoMatriks] $nt[NamaPelajar] $nt[NoIC] $nt[Bangsa]<br> ";    

Source: plus2net