} $result = DB_query($sql, $db); echo '<table border="0" width="98%" class="selection">'; echo '<tr><th>' . _('Date/Time') . '</th> <th>' . _('User') . '</th> <th>' . _('Type') . '</th> <th>' . _('Table') . '</th> <th>' . _('Field Name') . '</th> <th>' . _('Value') . '</th></tr>'; while ($myrow = DB_fetch_row($result)) { if (Query_Type($myrow[2]) == "INSERT") { InsertQueryInfo(str_replace("INSERT INTO", '', $myrow[2])); $RowColour = '#a8ff90'; } if (Query_Type($myrow[2]) == "UPDATE") { UpdateQueryInfo(str_replace("UPDATE", '', $myrow[2])); $RowColour = '#feff90'; } if (Query_Type($myrow[2]) == "DELETE") { DeleteQueryInfo(str_replace("DELETE FROM", '', $myrow[2])); $RowColour = '#fe90bf'; } if (trim($_SESSION['SQLString']['table']) == $_POST['SelectedTable'] || $_POST['SelectedTable'] == 'ALL') { if (!isset($_SESSION['SQLString']['values'])) { $_SESSION['SQLString']['values'][0] = ''; } echo '<tr style="background-color: ' . $RowColour . '"> <td>' . $myrow[0] . '</td> <td>' . $myrow[1] . '</td> <td>' . Query_Type($myrow[2]) . '</td> <td>' . $_SESSION['SQLString']['table'] . '</td>
} $result = DB_query($sql, $db); echo '<TABLE BORDER=0 width="100%">'; echo '<TR><TH>' . _('Date/Time') . '</TH> <TH>' . _('User') . '</TH> <TH>' . _('Type') . '</TH> <TH>' . _('Table') . '</TH> <TH>' . _('Field Name') . '</TH> <TH>' . _('Value') . '</TH></TR>'; while ($myrow = DB_fetch_row($result)) { if (Query_Type($myrow[2]) == 'INSERT') { InsertQueryInfo(str_replace("INSERT INTO", '', $myrow[2])); $RowColour = '#a8ff90'; } if (Query_Type($myrow[2]) == 'UPDATE') { UpdateQueryInfo(str_replace('UPDATE', '', $myrow[2])); $RowColour = '#feff90'; } if (Query_Type($myrow[2]) == 'DELETE') { DeleteQueryInfo(str_replace('DELETE FROM', '', $myrow[2])); $RowColour = '#fe90bf'; } if (trim($_SESSION['SQLString']['table']) == $_POST['SelectedTable'] || $_POST['SelectedTable'] == 'ALL') { if (!isset($_SESSION['SQLString']['values'])) { $_SESSION['SQLString']['values'][0] = ''; } echo '<TR style="background-color: ' . $RowColour . '"> <TD>' . $myrow[0] . '</TD> <TD>' . $myrow[1] . '</TD> <TD>' . Query_Type($myrow[2]) . '</TD> <TD>' . $_SESSION['SQLString']['table'] . '</TD>