1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| <?php
$collec= $_GET['id'];
/* Affichage des collections */
$sql->DatabaseConnexion();
$aff_collections_titre = $sql->query("SELECT * FROM "._TCOLLECTIONS_." WHERE id_univers_collec='$collec'")or die (mysql_error());
$sql->DatabaseClose();
while ($titre_results = mysql_fetch_array($aff_collections_titre,MYSQL_ASSOC)) {
$tpl->assign_block_vars('collections', array(
'TITRE_COLLEC' => $titre_results['titre_collec'],
'TEXTE_COLLEC' => $titre_results['texte_collec'],
));
}
/* Affichage des photos correspondantes aux collections */
$sql->DatabaseConnexion();
$aff_collections_photo = $sql->query("SELECT * FROM "._TCOLLECTIONS_PHOTOS_." LEFT JOIN "._TCOLLECTIONS_." ON "._TCOLLECTIONS_PHOTOS_.".id_collection_photo = "._TCOLLECTIONS_.".id_collection") or die (mysql_error());
$sql->DatabaseClose();
while ($photo_results = mysql_fetch_array($aff_collections_photo,MYSQL_ASSOC)) {
$tpl->assign_block_vars('collections.photos', array(
'PHOTO_NORMAL' => $photo_results['photo_normal'],
));
}
?> |
Partager