"); $query="SELECT * FROM pfiles where account='" . $username . "'"; $result = mysql_query($query); while($r=mysql_fetch_array($result)) { $name=$r["name"]; $state=$r["create_state"]; switch($state){ case "-1": $verbal_state = " (declined)"; break; case "0": $verbal_state = " (deceased)"; break; case "1": $verbal_state = " (submitted)"; break; case "2": $verbal_state = " (active)"; break; case "3": $verbal_state = " (unknown)"; break; case "6": $verbal_state = " (declined)"; break; case "7": $verbal_state = " (under review)"; break; default: $verbal_state = " (stabled)"; } echo ("" . $name . " " . $verbal_state . "
"); } echo("
"); require("include/bottom.inc"); ?>