Help sorting results

[pelillom]

I have a set of results that I am pulling from a database. If the Get variables of "sortby" and "order" are not set, then I use default values. On the generated page I have different links which specify the "sortby" variable and a function that ATTEMPTS to determine the current "order" and get the reverse of it.

So if I click on the link once it will sort in ASC order and a second time in DESC order. The function works but only on every other link.

I have four links on the page, RFQ#, Customer PN, Company PN and Date. RFQ#, and Company # will work just fine, but Customer PN and Date won't work. I am not getting errors in the log, but it just doesn't seem to be picking up the values.

here is the reverse sort function
function get_opposite_order($input, $order) ## Get opposite order
{
if ($GET["order"] == "ASC"){
$GET["order"]= "DESC";
return $GET["order"];
} else {
$GET["order"]= "ASC";
return $_GET["order"];
}
}

The links all follow the same principal
<a href="<?php echo $hef."&amp;order=".get_opposite_order("Receive_Date", $_GET["order"]);?>">Receive Date</a>

The mysql statement looks like this
$SESSION["search_query"]="select * from tracking_quote where Status != 'COMPLETE' ";
$SESSION["search_query"].= "order by tracking_quote.";

	if (!isset($_GET['sortby'])) {
		$_SESSION["search_query"].= "date_modified";
		$_GET["sortby"]="date_modified";
	} else {
		$_SESSION["search_query"].= $_GET["sortby"];
	}

	if (!isset($_GET['order'])) {
		$_SESSION["search_query"] .= " DESC";
		$_GET['order']= "DESC";
	} else {
		$_SESSION["search_query"] .= " ". $_GET['order'];
	}

Any thoughts or suggestions? The every other issue really has me stumped.

[bogu]

Did u check your select for each type of ordering and its ok?

Who is $_GET["order"], inside your get_opposite_order function? is it knowen in there what values does it have?

pelillom wrote:

RFQ#, and Company # will work just fine

I dont think so ...

Why does your function have 2 params, if u dont use them?

U should read a little about Function arguments.

And when u post code on the forum please encapsulate it between [ php]...[ /php] tags.

[void_function]

Just a stupid question, but are you actually sending SQL query via session and executing it FROM session variable?

[pelillom]

I would like to say that $_GET["order"] is known inside the function because it works sometimes.

The default action of the page is to build $SESSION["search_query"] and the order and sortby are defined. When the page loads, the links allow the user to change the sortby and order. if you click on RFQ#, then it works great and sorts the order ascending and descending and back again, all day long. However if you click Customer_PN, is only sorts in ascending. You can click all day long and it will never change the order. So in this case I don't think it does know what $get["order"] is.

The reason for two inputs, originally when I coded it, I was trying have it determine if the current "sortby" and the "sortby" of the previous search where the same. If then were not, then always make the "order" ascending. Since I was having so many problem, I have removed that portion of the code from the function, but not from the function call.

Is that possibly part of the problem?