gistfile1.php

<?php

/**
 * sample sql
 *
  SELECT
  a.state, count(b.id) AS total
  FROM state a
  LEFT JOIN data b ON a.id=b.state_id
  GROUP BY a.id
 *
 */
$sample_result = array(
    array(
        'state' => 'johor',
        'total' => 87851
    ),
    array(
        'state' => 'kedah',
        'total' => 4626
    ),
    array(
        'state' => 'kelantan',
        'total' => 894
    ),
    array(
        'state' => 'melaka',
        'total' => 2129
    )
);

$stateRow = '';
$totalRow = '';
foreach ($sample_result as $row) {
    $stateRow .= '<td>' . $row['state'] . '</td>';
    $totalRow .= '<td>' . $row['total'] . '</td>';
}

echo '<table border="1">';
echo '<tr><td>Negeri</td>' . $stateRow . '</tr>';
echo '<tr><td>Bilangan</td>' . $totalRow . '</tr>';
echo '</table>';