Create a 'sort by' combobox for pager_query results

Would it be possible to do this sort of thing with views + cck? i don't know anything about cck so would it allow me to add custom fields to filter a view on? Or is there a way to add custom fields to views with another module?

I tried writing some code as a PHP snippet for what i want but i'm not sure how to get it to work.

<?php

	$output = "";
	if ($sort == ""){
		$sort = t('L.nid desc');
	};
	$SQL = "SELECT L.nid
			FROM {rlisting_listing} L
			WHERE (L.building_type_id = 1 OR L.building_type_id = 3 OR L.building_type_id = 4)
					AND L.listing_type_id = 2
					AND (L.listing_status = ".AVAILABLE_LISTING." OR L.listing_status = ".AVAILABLE_SOON.")
					ORDER BY $sort
	";
	$result = pager_query($SQL,40,0);
	if (db_num_rows($result) > 0){
		while ($record = db_fetch_object($result)){
			$nodes .= node_view(node_load($record->nid),true);
		};
	}else{
		$output  = "There were no results found";
	};
	$output = drupal_get_form('sortby_dropdown_form', $form);
	$output .= $nodes;
	$output .= theme('pager',NULL,40,0);

	return $output;

function sortby_dropdown_form() {
$formname="sortby";
$sortby_array = array (
	t('L.nid desc')	=> t('newest'),
	t('L.nid ')	=> t('oldest'),
);
 $form['sortby'] = array(
      '#type' => 'select',
      '#name' => $formname,
      '#id' => $formname,
      '#title' => '',
      '#default_value' => '',
      '#options' => $sortby_array,
      '#description' => '',
      '#multiple' => $multiple = FALSE,
      '#required' => $required = FALSE,
      // '#attributes' => array('onChange' => $sort = $form['sortby']['#value'], then run the SQL select statement again and page the results???),
    );
        return $form;
}
?>

Basically all i want to do is allow visitors to sort the results using a combo box. Anyone have any ideas?

I'm still trying to write some code that will enable a user to order / sort a list of teaser nodes but i can't figure out how to get it to work. This is what i have so far;

<?php

	// default sort value
	$sortby = "L.nid desc";

	$output = "";
	$SQL = "SELECT L.nid
			FROM {rlisting_listing} L
			WHERE (L.building_type_id = 1 OR L.building_type_id = 3 OR L.building_type_id = 4)
					AND L.listing_type_id = 2
					AND (L.listing_status = ".AVAILABLE_LISTING." OR L.listing_status = 

".AVAILABLE_SOON.")
					ORDER BY $sortby
	";
	$result = pager_query($SQL,40,0);
	if (db_num_rows($result) > 0){
		while ($record = db_fetch_object($result)){
			$nodes .= node_view(node_load($record->nid),true);
		};
	}else{
		$output  = "There were no results found";
	};
	$output = drupal_get_form('sortby_dropdown_form', $form);
	$output .= $nodes;
	$output .= theme('pager',NULL,40,0);

	return $output;


function sortby_dropdown_form() {

$formname="sortby";
$sortby_array = array (
	t('L.nid desc')	=> t('newest'),
	t('L.city_name ')	=> t('suburb'),
	t('L.price desc')	=> t('price'),
);
 $form['sortby'] = array(
      '#type' => 'select',
      '#name' => $formname,
      '#id' => $formname,
      '#title' => '',
      '#default_value' => '',
      '#options' => $sortby_array,
      '#description' => '',
      '#multiple' => $multiple = FALSE,
      '#required' => $required = FALSE,
	// upon changing the dropdown box, reorder the SQL results with the new ORDER BY
	'#attributes' => array('onChange' => sort_results()),
    );

        return $form;
}

function sort_results(){

//set sort by variable as the value chosen in the dropdown box
$sortby = $form['sortby']['#value'];

	$output = "";
	$SQL = "SELECT L.nid
			FROM {rlisting_listing} L
			WHERE (L.building_type_id = 1 OR L.building_type_id = 3 OR L.building_type_id = 4)
					AND L.listing_type_id = 2
					AND (L.listing_status = ".AVAILABLE_LISTING." OR L.listing_status = 

".AVAILABLE_SOON.")
					ORDER BY $sortby
	";
	$result = pager_query($SQL,40,0);
	if (db_num_rows($result) > 0){
		while ($record = db_fetch_object($result)){
			$nodes .= node_view(node_load($record->nid),true);
		};
	}else{
		$output  = "There were no results found";
	};
	$output = drupal_get_form('sortby_dropdown_form', $form);
	$output .= $nodes;
	$output .= theme('pager',NULL,40,0);

	return $output;
}

can anyone see what is wrong with this code? When i try to preview this as a PHP snippet it crashes apache (on xampp).