SQL Veriyi listele

<?php
	$SQL = "SELECT * FROM uye";
	
	$a = $_GET['action'];
	
	switch($a){
		case "acik":
			$SQL = mysql_query($SQL . "ORDER BY stat ASC");
			break;
		case "kapali":
			$SQL = mysql_query($SQL . "ORDER BY stat DESC");
			break;
		case "Name-ASC":
			$SQL = mysql_query($SQL . "ORDER BY name ASC");
			break;
	}
?>

$x = $_GET['action'];
$sorgu = mysql_query("SELECT * FROM uye ORDER BY $x");
while($row = mysql_fetch_assoc($sorgu)) {
....
}

if( !empty( $_GET['orderby'] ) ){
  $orderby = $_GET['orderby'];
} else {
  $orderby = 'id';
}
if( !empty( $_GET['sira'] ) ){
  $sıra = $_GET['sira'];
} else {
  $sıra = 'desc';
}

mysql_query('select * from uye order by '.$orderby.' '.$sıra)