CLick on Title to Sort Ascending - Descending

[jadi]

This php works and displays a table. What I want to do here is that if i click the title of the column it should do ascending and descending order with evry click.

Please help me work with my code.???

<?php
$host = "localhost";
$user = "xxxx";
$pass = "xxxx";
$dbname = "xxx";

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL server: " . mysql_error());
$db_selected = mysql_select_db('xxx', $connection);

$dt= DATE('Y-m-d');
$data = mysql_query("SELECT * FROM xxx where date = '$dt'")
or die(mysql_error());
Print "<table border=0 cellspacing=0 cellpadding=0 style='width:100%'>";


$info= mysql_query($query);
$num_data = mysql_num_rows($data);

for($i=0; $i < $num_data; $i++) {

$row = mysql_fetch_array($data);

$rows[$i]['BSCID'] = "<td style='text-align:left'>" . $row['BSCID'] . "</td>";

$rows[$i]['Cellid'] = "<td style='text-align:left'>" . $row['Cellid'] . "</td>";

$rows[$i]['Seiz'] = "<td>" . $row['Seiz'] . "</td>";
$rows[$i]['Drps'] = "<td>" . $row['Drps'] . "</td>";
$rows[$i]['RF'] = "<td>" . $row['RF'] . "</td>";
$rows[$i]['Oth'] = "<td>" . $row['Oth'] . "</td>";
$rows[$i]['Traff'] = "<td>" . $row['Traff'] . "</td>";
$rows[$i]['Total'] = "<td>"."(" . $row['Total'] .")". "</td>";

$rows[$i]['DIT'] = "<td>" . $row['DIT'] . "</td>";

$rows[$i]['IHFL'] = "<td>" . $row['IHFL'] . "</td>";
$rows[$i]['TCD'] = "<td>" . $row['TCD'] . "</td>";
$rows[$i]['TCA'] = "<td>" . $row['TCA'] . "</td>";
$rows[$i]['SDD'] = "<td>" . $row['SDD'] . "</td>";
$rows[$i]['SDA'] = "<td>" . $row['SDA'] . "</td>";
$rows[$i]['TAVL'] = "<td>" . $row['TAVL'] ."%". "</td>";
$rows[$i]['Drate'] = "<td>" . $row['Drate'] . "</td>";

if($row['dropflag'])
$rows[$i]['Drps'] = str_replace('<td>','<td style="font-weight:bold;color:#CC0066">',$rows[$i]['Drps']);

if($row['trafflag'])
$rows[$i]['Traff'] = str_replace('<td>','<td style="font-weight:bold;color: #CC0066">',$rows[$i]['Traff']);

if($row['ihfflag'])
$rows[$i]['IHFL'] = str_replace('<td>','<td style="font-weight:bold;color:#CC0066">',$rows[$i]['IHFL']);

if($row['tchaflag'])
$rows[$i]['TAVL'] = str_replace('<td>','<td style="font-weight:bold;color:#CC0066 ">',$rows[$i]['TAVL']);

}

for($i=0; $i < $num_data; $i++) {

if($i % 2)
{
print '<TR bgcolor="#ffffff">';
}
else
{
print '<TR bgcolor="#CCCCCC">';
}

foreach($rows[$i] as $cell)
echo $cell;
}

print "</TR>\n";

?>

MOD EDIT: PHP BBcode tags added - please use these in the future!

[bpat1434]

Well for starters you had a syntax error on line 8 which I fixed for you (you were missing a closing ' after xxx).

The typical way to do this is to add a link with specific _GET vars. I implemented this for a project years ago (PHP Support Tickets) by adding ?sort=colname&dir=direction as the href values for links in the headers.

The thing is, I don't see any table headers so you'll need to add those. Other than that, it's as easy as making the <th> elements have links that look like:

echo '<th><a href="?sort=' . $column . '&dir=' . $direction . '">' . $columnName . '</a></th>';

Then in your php, just see if the _GET values are set. If they are, appropriately account for them:

$query = "SELECT * FROM xxx where date = '$dt'";

if(isset($_GET['column']))
{
  // Order by the column
  $query .= "ORDER BY " . $_GET['column'];

  if(isset($_GET['dir']))
    $query .= " " . $_GET['dir'];
}
else
{
  // Default sort order
  $query .= "";
}

$data = mysql_query($query) or die('MYSQL Error');

So in the end you'd have links that looked like this in the URL:

?sort=Seiz&dir=ASC
?sort=Seiz&dir=DESC
?sort=BSCID&dir=ASC
?sort=BSCID&dir=DESC
?sort=Cellid&dir=ASC
....

Hope that helps.