Re: Column Sort Question

Hello!! Is the refresh built in or do you mean when someone clicks the refresh button on thier browser??? If it's built in...using header()....You could pass the values of $sort_order and $order_by just by adding at the end of the url that is refreshed... Or something like that...since your using Sessions... Dan On Tuesday, April 15, 2003, at 01:03 PM, jpweb63@hotmail.com wrote:

Hi All, I am a newbie at this stuff so I hope this makes sense. I want clickable column headings in a table that sort on click. I got it working using the code below but can't figure out how to get past the issue of the refresh button. I only want it sort when a column is clicked. Ever time Refresh is hit it toggles my sort routine. I understand why it's doing it in my code but I can't figure out how to code around the Refresh. Thank, Jerry $default_sort_order = 'asc'; $default_order_by = "Application"; $order_by = $_GET['order_by']; if (empty($order_by)) { $order_by = $default_order_by; } $sort_order=$_SESSION['sort_order']; if (empty ($sort_order)) { $sort_order = $default_sort_order; $_SESSION['sort_order'] = $sort_order; }else{ if (($_SESSION['sort_order'] == 'asc') && ($_SESSION['last_infield'] == $order_by)) { $sort_order = 'desc'; $_SESSION['sort_order'] = 'desc'; }else{ $sort_order = 'asc'; $_SESSION['sort_order'] = 'asc'; } } $_SESSION['last_infield'] = $order_by; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php