$query = "SELECT * FROM mp_accueil WHERE pseudo='".$owner."' ORDER BY id DESC LIMIT 1";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$contenu = explode("\n",$row{'contenu'});
foreach($contenu as $key)
{
print "\t
$key
\n";
}
?>
$query = "SELECT * FROM mp_pigeon WHERE pseudo='".$owner."' ORDER BY note DESC, concours DESC LIMIT 3";
$result = mysql_query($query) or die(mysql_error());
$i = 0;
while($row = mysql_fetch_assoc($result))
{
$row{'date'} = preg_replace("/([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})/","$3/$2/$1",$row{'date'});
echo "
Bague: ".$row{'bague'}."
Né le : ".$row{'date'}."
Note : ".$row{'note'}."
";
}
?>
$query = "SELECT count(id) FROM mp_pigeon WHERE pseudo='".$owner."'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo "\t
Total de ".$row{0}." pigeons appartenant à ".$owner.".
\n";
$query = "SELECT sum(concours) FROM mp_pigeon WHERE pseudo='".$owner."'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo "\t
Nombre de concours : ".$row{0}."
\n";
$query = "SELECT bague FROM mp_pigeon WHERE pseudo='".$owner."' ORDER BY id DESC LIMIT 1";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo "\t
Bague du dernier pigeon ajouté : ".$row{0}."
\n";
?>