i would like to return the $result in a <table> where
i can control the column name.
lets say:
info_uk = "this is a good event"
information = info_uk
so it shows in my table
information: "this is a good event"
how can make it so the column name is hidden but i return
the hidden columns value?
my code for show.php:
if (isset($_GET['id'])) {
$id = sqlite_escape_string($_GET['id']);
$query = "SELECT title, info_dk, land, vol, size, price FROM $table WHERE item_id='$id'";
$result = sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
$row = sqlite_fetch_array($result);
echo '<TABLE border="1" width="200">';
for ( $i = 0; $i <= sqlite_num_fields($result)-1; $i += 1) {
echo '<TR>';
echo '<TD CLASS="itemName">' .sqlite_field_name($result, $i). '</TD>';
echo '<TD CLASS="itemValue">' .$row[$i]. '</TD>';
echo '</TR>';
}
echo '</TABLE>';
is it like this?
echo "<td>"information:.$row[3]."</td>;
or something like it?