Requette mysql ds un code php

Bonjour,
voila tout le code ,les opérations d'insertion et de supression marchent mais l'oppération d'affichage ne marche pas je sais pas ou se trouve le plme
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?Php
$Code=$_POST['Code'];

//connection bdd
$connect=mysql_connect("localhost","root","") or die("connexion impossible ".mysql_error());
mysql_select_db("observatoire",$connect) or die("Pb selection base ".mysql_error());
if(isset($_POST['inserer'])){
$request= "INSERT INTO loyer(LOY_C) VALUES ('$Code')";
$resultat=mysql_query($request,$connect)or die("plme de requete ".mysql_error());
}
if(isset($_POST['supprimer']))
{
$request = "DELETE FROM loyer WHERE LOY_C='$Code'";
$resultat = mysql_query( $request, $connect ) or die( "plme de requete " . mysql_error() );

}
if(isset($_POST['afficher']))
{
$request = "SELECT FROM loyer WHERE LOY_C='$Code'";
$resultat = mysql_query( $request, $connect ) or die( "plme de requete " . mysql_error() );

}
mysql_close($connect);
?>
</body>
</html>

Configuration: Windows XP
Internet Explorer 7.0