sorting by column heads

Original - php Code echo "<TD><a href="$MM_keepNone.(($MM_keepNone!="")?"&":"")."id=".$row_users['id']">edit</a></TD>";

 
echo "<TD><a href="$MM_keepNone.(($MM_keepNone!="")?"&":"")."id=".$row_users['id']">edit</a></TD>"; 

Original - php Code <?PHP /* set the allowed order by columns */ $default_sort = 'username'; $allowed_order = array ('id', 'lname','fname', 'username', 'status', 'email'); /* if order is not set, or it is not in the allowed * list, then set it to a default value. Otherwise, * set it to what was passed in. */ if (!isset ($_GET['order']) || !in_array ($_GET['order'], $allowed_order)) { $order = $default_sort; } else { $order = $_GET['order']; } /* connect to db */ //mysql_connect ('localhost','user','pass'); //mysql_select_db ('test'); /* construct and run our query */ $query = "SELECT * FROM log_in ORDER BY $order"; $result = mysql_query ($query); /* make sure data was retrieved */ $numrows = mysql_num_rows($result); if ($numrows == 0) { echo "No data to display!"; exit; } /* now grab the first row and start the table */ $row = mysql_fetch_assoc ($result); echo "<TABLE border=1>n"; echo "<TR>n"; foreach ($row as $heading=>$column) { /* check if the heading is in our allowed_order * array. If it is, hyperlink it so that we can * order by this column */ echo "<TD><b><font size=-1>"; if (in_array ($heading, $allowed_order)) { echo "<a href="{$_SERVER['PHP_SELF']}?order=$heading">$heading</a>"; } else { echo $heading; } echo "</b></TD>n"; } echo "<TD>edit</TD>"; echo "</TR>n"; /* reset the $result set back to the first row and * display the data */ mysql_data_seek ($result, 0); while ($row = mysql_fetch_assoc ($result)) { echo "<TR>n"; foreach ($row as $column) { echo "<TD><font size=-1>$column</TD>n"; } echo "<TD><a href="$MM_keepNone.(($MM_keepNone!="")?"&":"")."id=".$row_users['id']">edit</a></TD>"; echo "</TR>n"; } echo "</TABLE>n"; ?>

 
<?PHP
/* set the allowed order by columns */
$default_sort = 'username';
$allowed_order = array ('id', 'lname','fname', 'username', 'status', 'email');
 
/* if order is not set, or it is not in the allowed
* list, then set it to a default value. Otherwise, 
* set it to what was passed in. */
if (!isset ($_GET['order']) || 
    !in_array ($_GET['order'], $allowed_order)) {
    $order = $default_sort;
} else {
    $order = $_GET['order'];
}
 
/* connect to db */
//mysql_connect ('localhost','user','pass');
//mysql_select_db ('test');
 
/* construct and run our query */
$query = "SELECT * FROM log_in ORDER BY $order";
$result = mysql_query ($query);
 
/* make sure data was retrieved */
$numrows = mysql_num_rows($result);
if ($numrows == 0) {
    echo "No data to display!";
    exit;
}
 
/* now grab the first row and start the table */
$row = mysql_fetch_assoc ($result);
echo "<TABLE border=1>n";
echo "<TR>n";
foreach ($row as $heading=>$column) {
    /* check if the heading is in our allowed_order
     * array. If it is, hyperlink it so that we can
     * order by this column */
    echo "<TD><b><font size=-1>";
    if (in_array ($heading, $allowed_order)) {
        echo "<a href="{$_SERVER['PHP_SELF']}?order=$heading">$heading</a>";
    } 
    else {
        echo $heading;
    }                
    echo "</b></TD>n";
    } 
    echo   "<TD>edit</TD>";
    echo "</TR>n";
 
/* reset the $result set back to the first row and 
* display the data */
mysql_data_seek ($result, 0);
while ($row = mysql_fetch_assoc ($result)) {
    echo "<TR>n";
    foreach ($row as $column) {
        echo "<TD><font size=-1>$column</TD>n";
    }
    echo "<TD><a href="$MM_keepNone.(($MM_keepNone!="")?"&":"")."id=".$row_users['id']">edit</a></TD>";
    echo "</TR>n";
}
echo "</TABLE>n";
?>