if(!empty($_GET[id_article])){
$res=mysql_query("SELECT id_article,titre,article,illustration,DATE_FORMAT(date,'%d/%m/%Y à %H:%i:%s') as date ,position FROM actualites WHERE id_article='$_GET[id_article]' ORDER BY date DESC ");
}else{
$res=mysql_query("SELECT id_article,titre,article,illustration,DATE_FORMAT(date,'%d/%m/%Y à %H:%i:%s') as date ,position FROM actualites ORDER BY date DESC ");
}
while($d=mysql_fetch_array($res)){
print('');
print(' '.$d[4].' ');
if(!empty($d[3])){
print(affiche($d[3]));
}
if(!empty($_GET[id_article])){
print(''.$d[2].' ');
}else{
$d[2]=strip_tags($d[2]);
print('');
$word=explode(" ",$d[2]);
for($i=0;$i<30;$i++){
print($word[$i].' ');
}
print(' (...) ');
}
}
?> |
$res=mysql_query("SELECT id_article, titre, DATE_FORMAT(date,'%d/%m/%Y') FROM actualites WHERE id_article!='$_GET[id_article]' ORDER BY date DESC LIMIT 0,5");
while($row=mysql_fetch_array($res)){
print(' ');
}
?>
GUIDE IMPORT EXPORT
$res=mysql_query("SELECT id_guide,rubrique FROM guide_rubrique WHERE parent='0'");
while($row=mysql_fetch_array($res)){
print(' ');
}
?>
$res=mysql_query("SELECT * FROM bibliotheque WHERE une='1'");
while($row=mysql_fetch_array($res)){
$id_livre=$row[0];
$titre=$row[1];
$auteur=$row[2];
$editeur=$row[3];
$prix=$row[4];
$presentation=$row[5];
$url=$row[7];
$illustration=$row[6];
$sommaire=$row[10];
}
print(' ');
print('
'.$titre.' |
');
if(!empty($illustration)){
print('
| Auteur : '.$auteur.'
Editeur : '.$editeur.'
Prix : '.$prix.'
|
');
?>
|