sorting by coloumn header

[mogi]

can some one help me, i want to be able to sort on click of a header in asc on second click of same head in dec. this code seem to sort in asc only, but i can't figure out what the problem is, some one help:

Code:
<table width="100%">
<?
global $order;
mysql_connect("localhost" , "solara", "pass") or die(mysql_error());
mysql_select_db("procurement");

//session_start();
echo("<tr>
<td>Acromy</td>
<td><a href=rank.php?order=VendorName>Vendor</a></td>
<td><a href=rank.php?order=cost>Cost</a></td>
<td><a href=rank.php?order=ToP>Term of Payment</a></td>
<td><a href=rank.php?order=Brand>Brand</a></td>
<td><a href=rank.php?order=ProType>Processor Type</a></td>
<td><a href=rank.php?order=ProSpeed>Processor Speed</a></td>
<td><a href=rank.php?order=HDsk>Hard Disk</a></td>
<td><a href=rank.php?order=Ram>RAM</a></td>
<td><a href=rank.php?order=DelivP>Delivery Period</a></td>
<td><a href=rank.php?order=waranty>Warranty</a></td>
<td><a href=rank.php?order=Tax>Tax</a></td>
</tr>");

$query = "select vendor.Acromy, vendor.VendorName,rfq.cost, rfq.ToP, rfq.Brand, rfq.ProType, rfq.ProSpeed, rfq.HDsk, rfq.Ram,rfq.DelivP, rfq.Waranty, rfq.Tax from vendor, rfq where vendor.UserName=rfq.UserName";

if($SESSION['field'] == $order) {
$SESSION['dir'] = ((empty($SESSION['dir'])) ? "asc" : $SESSION['dir']);
$SESSION['dir'] = (($SESSION['dir'] == "asc") ? "desc" : "asc");
}

if($order == "VendorName")
{
$SESSION['field'] = "VendorName";
$order_by = " order by vendor.VendorName ".$SESSION['dir'];
}
elseif($order == "cost")
{
$SESSION['field'] = "cost";
$order_by = " order by rfq.cost ".$SESSION['dir'];
}
elseif($order == "ToP")
{
$SESSION['field'] = "ToP";
$order_by = " order by rfq.ToP ".$SESSION['dir'];
}
elseif($order == "Brand")
{
$SESSION['field'] = "Brand";
$order_by = " order by rfq.Brand ".$SESSION['dir'];
}
elseif($order == "ProType")
{
$SESSION['field'] = "ProType";
$order_by = " order by rfq.ProType ".$SESSION['dir'];
}
elseif($order == "ProSpeed")
{
$SESSION['field'] = "ProSpeed";
$order_by = " order by rfq.ProSpeed ".$SESSION['dir'];
}
elseif($order == "HDsk")
{
$SESSION['field'] = "HDsk";
$order_by = " order by rfq.HDsk ".$SESSION['dir'];
}
elseif($order == "Ram")
{
$SESSION['field'] = "Ram";
$order_by = " order by rfq.Ram ".$SESSION['dir'];
}
elseif($order == "DelivP")
{
$SESSION['field'] = "DelivP";
$order_by = " order by rfq.DelivP ".$SESSION['dir'];
}
elseif($order == "Waranty")
{
$SESSION['field'] = "Waranty";
$order_by = " order by rfq.Waranty ".$SESSION['dir'];
}
elseif($order == "Tax")
{
$SESSION['field'] = "Tax";
$order_by = " order by rfq.Tax ".$SESSION['dir'];
}

$sth = mysql_query($query.$order_by);
while($row = mysql_fetch_array($sth)) {
echo "<tr>
<td>".$row['vendor.Acromy']."</td>
<td>".$row['vendor.VendorName']."</td>
<td>".$row['rfq.cost']."</td>
<td>".$row['rfq.ToP']."</td>
<td>".$row['rfq.Brand']."</td>
<td>".$row['rfq.ProType']."</td>
<td>".$row['rfq.ProSpeed']."</td>
<td>".$row['rfq.HDsk']."</td>
<td>".$row['rfq.Ram']."</td>
<td>".$row['rfq.DelivP']."</td>
<td>".$row['rfq.Waranty']."</td>
<td>".$row['rfq.Tax']."</td></tr>";
}
?>
</table>

[paulnaj]

Hi mogi,

I think I've sorted out the logic ... but I couldn't resist showing a (simple) way of getting rid of that huge list of 'ifs' ...

<?php 
session_start();
if(isset($_GET['order']){
	$order = $_GET['order'];
} else {
	// Set a default order
	$order = 'VendorName'; 
}

if(isset($_SESSION['field']) && $_SESSION['field'] == $order){
	$_SESSION['dir'] = ($_SESSION['dir'] == "asc")? "desc": "asc"; 
} else {
	// Either $_SESSION['field'] is not set, or $_SESSION['field'] != $order
	$_SESSION['field'] = $order;
	$_SESSION['dir'] = 'asc'; 
} 

mysql_connect("localhost" , "solara", "pass") or die(mysql_error()); 
mysql_select_db("procurement"); 

$query = "
SELECT 	vendor.Acromy, vendor.VendorName, rfq.cost, rfq.ToP, rfq.Brand, rfq.ProType, rfq.ProSpeed, rfq.HDsk, rfq.Ram, rfq.DelivP, rfq.Waranty, rfq.Tax 
FROM 	vendor 
JOIN	rfq USING (UserName)
ORDER BY ".($order == "VendorName"? "vendor": "rfq").".".$_SESSION['field']." ".$_SESSION['dir']."
"; 

$sth = mysql_query($query.$order_by); 
?>
<html>
<head>
<title>Test</title>
</head>
<body>
<table width="100%"> 
	<tr> 
		<td>Acromy</td> 
		<td><a href=rank.php?order=VendorName>Vendor</a></td> 
		<td><a href=rank.php?order=cost>Cost</a></td> 
		<td><a href=rank.php?order=ToP>Term of Payment</a></td> 
		<td><a href=rank.php?order=Brand>Brand</a></td> 
		<td><a href=rank.php?order=ProType>Processor Type</a></td> 
		<td><a href=rank.php?order=ProSpeed>Processor Speed</a></td> 
		<td><a href=rank.php?order=HDsk>Hard Disk</a></td> 
		<td><a href=rank.php?order=Ram>RAM</a></td> 
		<td><a href=rank.php?order=DelivP>Delivery Period</a></td> 
		<td><a href=rank.php?order=waranty>Warranty</a></td> 
		<td><a href=rank.php?order=Tax>Tax</a></td> 
	</tr>
<?php
while($row = mysql_fetch_array($sth)) { 
	echo "
	<tr> 
		<td>".$row['vendor.Acromy']."</td> 
		<td>".$row['vendor.VendorName']."</td> 
		<td>".$row['rfq.cost']."</td> 
		<td>".$row['rfq.ToP']."</td> 
		<td>".$row['rfq.Brand']."</td> 
		<td>".$row['rfq.ProType']."</td> 
		<td>".$row['rfq.ProSpeed']."</td> 
		<td>".$row['rfq.HDsk']."</td> 
		<td>".$row['rfq.Ram']."</td> 
		<td>".$row['rfq.DelivP']."</td> 
		<td>".$row['rfq.Waranty']."</td> 
		<td>".$row['rfq.Tax']."</td>
	</tr>
"; 
} 
?> 
</table>
</body>
</html> 

Hope that helps!

Paul 🙂