Better way to code this?

[penguinboy]

if($_SESSION[Type]=="Admin"){$sql = mysql_query("Select * from Powers where DisMM = ''");}
else{
	if($_SESSION[SURETYADMIN]){$sql = mysql_query("Select * from Powers where DisMM = '' and Surety='$_SESSION[SURETYADMIN]'");}
	else{
		if($_SESSION[BCOMPANYADMIN]){$sql = mysql_query("Select * from Powers where DisMM = '' and BondCompany='$_SESSION[BCOMPANYADMIN]'");}
		else{
			if($_SESSION[AGENT]){$sql = mysql_query("Select * from Powers where DisMM = '' and AgnID='$_SESSION[MYID]'");
			}
		}
	}
}

I was wondering if there was a better way to code this?
It works exactly like I want, but it looks.... dirty..

[RedDragon]

i dont know what your script does
but a select query has no sense if its not used later in the script, where is the fetch_array or the num_rows??????

if you think your scripts look dirty you might try using some more coding standarts...
formating the code over several lines, calling array with $x['name'] instead of $x[name] and so on...