help please! rookie needs advice

[kat89]

i have completed my admin.php.
here you can select a table and double click on the desired item for information. it direct to my show.php:

$db     = "c:/server/sqlite/selection.db";
  $handle = sqlite_open($db) or die("Could not open database");

    if (isset($_GET["tableName"])) {
			$table = sqlite_escape_string($_GET["tableName"]);


    if (isset($_GET['id'])) {
	    $id = sqlite_escape_string($_GET['id']);

    $query = "SELECT * FROM $table WHERE item_id='$id' ORDER BY item_id";

    $result	= sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));

how can i print the information from my item into table cells? can this be done
so retrive both colum name and info from my item?

[Installer]

If what you want to do is use the column names as table cell headings, this should work:

$res_arr = sqlite_fetch_all($result, SQLITE_ASSOC);
echo '<table><tr>';
foreach ($res_arr[0] as $column => $val) {
    echo '<th>' . $column . '</th>';
}
echo '</tr>';
foreach ($res_arr as $key => $row) {
    echo '<tr>';
    foreach ($row as $item) {
        echo '<td>' . $item . '</td>';
    }
    echo '</tr>';
}
echo '<table>';