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 47 48 49 50 51 52 53 54 55 56 57 58 59 60
| <?php
$description = "";
$keywords = "";
$subject = "";
$title = "";
$fakea = "";
$menu = true;
$body = '';
$liste_serie = mysql_query('SELECT distinct designation_type, id_type
FROM (typserie INNER JOIN proposer ON proposer.id_typeserie = typserie.id_type)
INNER JOIN marque ON marque.id_marque = proposer.id_marque
WHERE marque.id_marque = '.$_GET['marque']);
while( $serie = mysql_fetch_array($liste_serie) )
{
$body.='<div class="liste">
<div class="listeNom">';
// strtolower($variable) = renvoi le contenu de "variable" en minuscule
$body.='<a href="index.php?marque='.$_GET['marque'].'&type='.strtolower($serie['id_type']).'">'.$serie['designation_type'].'</a>
</div>
<table class="listeTableau2">
<tr>
<td><div class="Image"><img src="images/serie/'.strtolower($serie['designation_type']).'.gif"></div></td>
<td>
<div class="DonneSource">
<b>Type:</b>'.$serie['designation_type'].'<br />
<b>Imprimante:</b>';
$chSQL=('SELECT nom_imprimante FROM typserie
INNER JOIN imprimante
ON typserie.id_type=imprimante.id_typeSerie = ' . $serie['id_type']);
$liste2 = mysql_query($chSQL);
echo "<br><b>Requete SQL : </b>".$chSQL."<br><b>Erreur MySQL : </b>".mysql_error()."<br><b>Lignes concernees : </b>".mysql_num_rows($liste2);
while( $serie2 = mysql_fetch_array($liste2) )
{
$body.=' ['.$serie2['nom_imprimante'].']';
}
$body.='
</div>
</div>
</td>
</tr>
</table>
</div>';
}
?> |
Partager