Code: Select all
<?php
foreach ($row as $heading=>$column) {
echo "<TD><b>";
if (in_array ($heading, $allowed_order)) {
echo "<a href="{$_SERVER['PHP_SELF']}?order=$heading">$heading</a>";
}
else
{
echo $heading;
}
echo "</b></TD>\n";
}
echo "</TR>\n";
/* reset the $result set back to the first row and
* display the data */
mysql_data_seek ($result, 0);
$i = 0; // sets up the counter for alternating table row colors.
while ($row = mysql_fetch_assoc ($result)) {
echo "<TR>\n";
foreach ($row as $column) {
//My alternating colors
if($i % 2 == 0) //checks to see if the line is an even number
{
echo "<td font face="Arial" valign="center" bgcolor="#EEF7ff">";
}else{
// The whole purpose of this second area is to just change the highlighting of the table
echo "<td font face="Arial" valign="center" bgcolor="#DBEDff">";
}
//End Alternating colors
if ($column == $column["id"]){
echo ("<a href="editentry.php?id=$column">$column</a></TD>");
}else{
echo "$column</TD>\n"; // Original display
}
}
echo "</TR>\n";
$i++;
}
echo "</TABLE>\n";
echo "</table>";
?>Code: Select all
<TR>
<td font face="Arial" valign="center" bgcolor="#EEF7ff"><a href="editentry.php?id=4">4</a></TD><td font face="Arial" valign="center" bgcolor="#EEF7ff">some title</TD>
<td font face="Arial" valign="center" bgcolor="#EEF7ff">Tree Glitch: Jump out of world.</TD>
<td font face="Arial" valign="center" bgcolor="#EEF7ff">locationTD>
<td font face="Arial" valign="center" bgcolor="#EEF7ff">00:00:00</TD>
<td font face="Arial" valign="center" bgcolor="#EEF7ff">so on and so forthTD>
<td font face="Arial" valign="center" bgcolor="#EEF7ff"><a href="editentry.php?id="></a></TD></TR>Rand