$id = $_GET['id']; // Connexion à la base de donnée include("/var/www/virtual/serie-souslesoleil.com/htdocs/config.inc.php"); // Sélection du blog $sqlblog = mysql_query("SELECT * FROM blog WHERE name ='{$id}'"); while($voirblog = mysql_fetch_array($sqlblog)){ echo"
| "; echo""; echo" ^ "; echo"$titre"; echo" |
";
echo"
"; echo" "; echo" "; echo""; echo" "; echo" "; $sql_liens = mysql_query("SELECT * FROM blog_liens WHERE blog = '{$idblog}'"); if(mysql_num_rows($sql_liens)>0){ echo 'Mes meilleurs liens '; } while($aff_liens = mysql_fetch_array($sql_liens)){ echo ''.$aff_liens['des'].' '; } $sql_carticle = mysql_query("SELECT * FROM blog_article WHERE blog = '{$idblog}'"); $nbarticle = mysql_num_rows($sql_carticle); echo ' '.$nbarticle.' article(s) ';
$nbcom = 0;
while($affca = mysql_fetch_array($sql_carticle)){
$sql_com = mysql_query("SELECT * FROM blog_com WHERE article = '{$affca['id']}'");
$nbacom = mysql_num_rows($sql_com);
$nbcom = $nbcom+$nbacom;
}
echo ''.$nbcom.' commentaire(s) ';
echo" | "; // Colonne 2 echo" | ";
$page = $_GET['p'];
$page = (($page+1)*8)-8;
$sqlarticle = mysql_query("SELECT * FROM blog_article WHERE blog ='$idblog' ORDER BY id DESC LIMIT {$page},8");
while($voirarticle = mysql_fetch_array($sqlarticle)){
echo" ".$voirarticle['titre']." "; echo"- ".$voirarticle['date']." à ".$voirarticle['heure']." ";
echo"
";
echo" ";
echo"
| ";
// Colonne 3
echo"";
echo"Accueil";
echo"Album photos";
$sql_rub = mysql_query("SELECT * FROM blog_pages WHERE blog ='".$idblog."'");
while($aff_rub = mysql_fetch_array($sql_rub)){
echo ''.$aff_rub['titre'].'';
}
$count = strlen($photog);
if($count>0){
echo" "; } echo"
| ";
echo"