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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
|
<?php
//connection a la BDD
include('connection.php');
include('index.php');
$req = "SELECT * FROM rubri;";
$result=mysql_query($req);
while (list($NumRubrique, $NomRubrique) = mysql_fetch_array($result))
{
$req2=mysql_query("SELECT LienImage FROM imagereduite WHERE NumeroRubrique=".$NumRubrique.";");
$nb_result = mysql_num_rows($req2);
if($nb_result != 0)
{
$req3=mysql_query("SELECT LienImage FROM imageagrandie WHERE NumeroRubrique=".$NumRubrique.";");
$nb_result2 = mysql_num_rows($req3);
if($nb_result2 != 0)
{
$lien_image = mysql_result($req2, 0);
$lien_image2=mysql_result($req3, 0);
echo '<a href="photos/agrandies/'.$lien_image2.'" rel="lightbox"><img border="0" src="photos/reduites/'.$lien_image.'"></a>';
}
else
{
$lien_image = mysql_result($req2, 0);
echo '<img src="photos/reduites/'.$lien_image.'">';
}
}
}
echo "<u>"."<i>".$NumeroRubrique."<br>"."</i>"."</u>";
echo $NomRubrique."<br>";
?> |
Partager