my $query="SELECT severity, source, displayname FROM alert WHERE displayname LIKE '%$displayname%' ORDER BY severity DESC";
my $sth=$dbh->prepare($query);
$sth->execute();
#Loop through for each row returned
while ( @row = $sth->fetchrow_array ) {
	$severity = $row[0];
	$source = $row[1];
	$displayname = $row[2];
	print "$severity\n";
}