$display_p = "SELECT weapon_id,
weapon_name
FROM weapon
WHERE weapon_type='P'
ORDER BY weapon_id";

$query_p=@mysql_query($display_p,$dbac);
if (!$query_p) {
  echo 'Error retrieving weapons list';
}
$result_p=mysql_fetch_array($query_p);

var_dump($result_p);