rendered paste body $sql = "SELECT * FROM ad_user_types";
$params = array();
$res = $db->select($sql, $params);
$counter = 0;
$table = "<table border=1>";
while($row = $res->fetchRow()) {
if($counter == 0) {
$keys = array_keys($row);
$table .= "<tr>";
foreach($keys as $key) {
$table .= "<td>$key</td>";
}
$table .= "</tr>";
}
$table .= "<tr>";
foreach($row as $key => $value) {
$table .= "<td>$value</td>";
}
$table .= "<td>" . "<FORM METHOD=\"LINK\" ACTION=\"user_type.php?ad_ut_id=" . $row['ad_ut_id'] . '"><INPUT TYPE="submit" VALUE="Edit"></FORM>' . "</td><td>$deletebutton</td></tr>";
$counter++;
$table .= "\n";
}
$table .= "</table>";
echo "<pre>";
echo $table;
echo "</pre>";
<pre><table border=1><tr><td>ad_ut_id</td><td>ad_type</td><td>ad_sort</td><td>ad_active</td><td>ad_created</td><td>ad_updated</td></tr><tr><td>1</td><td>red</td><td></td><td>N</td><td>2006-12-26 10:30:11</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=1"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>2</td><td>active</td><td></td><td>Y</td><td>2006-12-26 11:20:49</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=2"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>3</td><td>A</td><td></td><td>Y</td><td>2006-12-27 12:39:16</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=3"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>8</td><td>WEDNESday</td><td></td><td>Y</td><td>2006-12-27 15:42:02</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=8"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>5</td><td>AMAZIng</td><td></td><td>Y</td><td>2006-12-27 12:43:06</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=5"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>9</td><td>THURSday</td><td></td><td>Y</td><td>2006-12-27 15:43:47</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=9"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>10</td><td>MONDAY</td><td></td><td>Y</td><td>2006-12-27 15:49:45</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=10"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>11</td><td>WESLEY</td><td></td><td>Y</td><td>2006-12-27 15:50:29</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=11"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>12</td><td>wes</td><td></td><td>Y</td><td>2006-12-27 15:51:55</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=12"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>13</td><td>yelsew</td><td></td><td>Y</td><td>2006-12-27 15:55:31</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=13"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>15</td><td>gfdghfd</td><td></td><td>Y</td><td>2006-12-27 15:57:05</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=15"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>16</td><td>gfdgfdgfd</td><td></td><td>Y</td><td>2006-12-27 15:57:47</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=16"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
<tr><td>18</td><td>wewew</td><td></td><td>Y</td><td>2006-12-27 15:59:22</td><td>0000-00-00 00:00:00</td><td><FORM METHOD="LINK" ACTION="user_type.php?ad_ut_id=18"><INPUT TYPE="submit" VALUE="Edit"></FORM></td><td><input name="delete" id="MCSPCDelete" type="Submit" value="Delete" tabindex="<?= ?>"></td></tr>
</table></pre>