Sort by Conditional Calculated Column

[kaneymac]

I have several calculated columns that I need to sort by (sort buttons in column headers). I've figured out most of the columns. However one uses several if statements to determine the calculation used on each row (see code below).

// Column: Payout
	if (($row['SoldBy']=='GT') && ($row['BookedBy']=='GT')) {
		$PayOut = 0;
		echo '<td bgcolor="fffff0">$'.number_format($PayOut,2,'.',',').'</td>';
	} 

elseif (($row['SoldBy']=='GT') && ($row['BookedBy']=='TC')) {
	$PayOut = $Margin*.2;
	echo '<td bgcolor="fffff0">$'.number_format($PayOut,2,'.',',').'</td>';
}

elseif (($row['SoldBy']=='GT') && ($row['BookedBy']=='')) {
	$PayOut = $Margin*.2;
	echo '<td bgcolor="fffff0">$'.number_format($PayOut,2,'.',',').'</td>';
}

elseif (($row['SoldBy']=='TC') && ($row['BookedBy']=='GT')) {
	$PayOut = $Margin*.4;
	echo '<td bgcolor="fffff0">$'.number_format($PayOut,2,'.',',').'</td>';
}

elseif (($row['SoldBy']=='TC') && ($row['BookedBy']=='TC')) {
	$PayOut = $Margin*.6;
	echo '<td bgcolor="fffff0">$'.number_format($PayOut,2,'.',',').'</td>';
}

elseif (($row['SoldBy']=='TC') && ($row['BookedBy']=='')) {
	$PayOut = $Margin*.6;
	echo '<td bgcolor="fffff0">$'.number_format($PayOut,2,'.',',').'</td>';
}

I know about including a "sum(ColumnA-Column😎 AS ColumnC" type of thing in my SELECT statement, but how can I sort this column since it's not just simple math, or even the same math used on each (depending on what's going on in my table-based columns of BookedBy and SoldBy?

Can provide more of the code if needed. Figured this would be enough hopefully.

[dagon]

can you show some actual db queries

[kaneymac]

here's the main query... and the if statements i've started adding to get the sort from the URL variables 'sort' and 'by' which are passed when click the sort icons on each column header

$sql = "SELECT * FROM sales_orders";

if (($_GET['by']=='QuoteNo') && ($_GET['sort']=='asc')) {
	$sql .= " ORDER BY QuoteNo asc";
}

elseif (($_GET['by']=='QuoteNo') && ($_GET['sort']=='desc')) {
	$sql .= " ORDER BY QuoteNo desc";
}

elseif (($_GET['by']=='TCPosted') && ($_GET['sort']=='asc')) {
	$sql .= " ORDER BY TCPosted asc";
}

elseif (($_GET['by']=='TCPosted') && ($_GET['sort']=='desc')) {
	$sql .= " ORDER BY TCPosted desc";
}

$result = mysql_query($sql) or die ("Connection failed.");

$i=0;

while ($row=mysql_fetch_assoc($result)) {
.
.
.

does that help?