query string

[sandy1028]

hi,

 

How to pass the query string when the single table to be sorted.

I just want to pass the query string for each column separately when clicked on the header.

When I click the column header it should sort in ascending when again clicked it should sort descending...

 

<a href="abc.php?name=asc ...........Name</a>

Please help me with this

[Philip]

<?php
echo "<a href='abc.php?col=name&type=asc'>name</a>";
//use an if statement to change the type to desc and back

$query = "SELECT * FROM `table` ORDER BY ".$_GET['col']. " ".$_GET['type'];
//Echo results however
?>

 

Make sure to clean the variables when you use GET, as people can change it.

[sandy1028]

Hi,

 

I am using files not mysql.

 

[sandy1028]

<a href=\"abc.php?name=asc\">Name</a>
<a href=\"abc.php?address=asc\">Address</a>

if($name == "asc")
{
$line1 = array();
foreach($lines as $line)
{
        $text_line=explode(":",$line);
        $line1[] = $text_line[0];
}

sort($line1);
for($i=0;$i<=count($line1);$i++){
echo "<td>--$line1[$i]</td>";
}

[sandy1028]

Hi,

 

How to sort the each column ascending and descending.

The sort of the column should not change when other column header is clicked