用列头排序查询结果

我有一个典型的SQL查询，返回如下结果:

$result_acc_man = "SELECT * FROM mgap_management WHERE account_manager_id = '" . $_SESSION['account_manager_id'] . "' ORDER BY mgap_sales_pres";
$stmt = $pdo->prepare($result_acc_man); 
$stmt->execute();
while($row_acc_man = $stmt->fetch(PDO::FETCH_ASSOC))
{
$salespres = $row_acc_man['mgap_sales_pres'];
$regvp = $row_acc_man['mgap_regional_vp'];
$areasales = $row_acc_man['mgap_area_sales_manager']
?>
<p class="asminfo"><span>Your ASM: <?php echo $areasales;?></span></p>
<p class="asminfo"><span >Your Regional VP: <?php echo $regvp; ?></span></p>
<p class="asminfo"><span >Your Sales President: <?php echo $salespres; ?></span></p>         
<?php
}
?>

这里是列标题

<div id="viewheadaccept">
            <span class="namecustaccept1">ACCOUNT NAME </span> 
            <span class="custaccept">ACCOUNT TYPE</span>
            <span class="recoverycustaccept">OPPORTUNITY SIZE</span>  
</div>

我需要添加单击列名和对数据排序的功能。除了创建包含排序的不同查询的多个链接页面之外，有没有更简单的方法来实现这一点?

谢谢!