prettyPrintSQLResult.php

<?php
function prettyPrintSQLResult($result) {
    $i=0;
    echo '<table border="1">';
    while ($data = $result->fetch_assoc()) {
        if (!$i) {
            //first entry
            $columns = array_keys($data);
            echo '<tr>';
            foreach($columns as $c) {
                echo '<th nowrap><strong>'.$c.'</strong></th>';
            }
            echo '</tr>';
        }
        echo '<tr>';
        foreach($data as $value) {
            echo '<td nowrap>'.$value.'</td>';
        }
        echo '</tr>';
        $i++;
    }
    echo '</table>';
}
?>