Fotografie if ($_GET['idcat']) { $sqlft0 = "SELECT * FROM gallery WHERE id='".$_GET['idcat']."' AND online='S'"; $execft0 = mysql_query($sqlft0,$conn) or die("Errore: ".mysql_error()); $risft0 = mysql_fetch_array($execft0); print " - ".$risft0['titolo']; } ?>
if ($_GET['idcat']) {?> $sqlft = "SELECT * FROM gallery WHERE id='".$_GET['idcat']."' AND online='S'"; $execft = mysql_query($sqlft,$conn) or die("Errore: ".mysql_error()); $risft = mysql_fetch_array($execft); for ($i=1; $i<=$risft['num_foto']; $i++) { if ($i<10) { $sqldd = "SELECT * FROM foto WHERE id_cat='".$_GET['idcat']."' AND foto='0".$i."' AND online='S'"; $execdd = mysql_query($sqldd,$conn) or die("Errore: ".mysql_error()); $risdd = mysql_fetch_array($execdd); if ($risdd['didascalia']=="") {?> } else {?> } } else { $sqldd = "SELECT * FROM foto WHERE id_cat='".$_GET['idcat']."' AND foto='".$i."' AND online='S'"; $execdd = mysql_query($sqldd,$conn) or die("Errore: ".mysql_error()); $risdd = mysql_fetch_array($execdd); ?> } }?> } else { $sqlct = "SELECT * FROM gallery WHERE online='S' ORDER BY ordine"; $execct = mysql_query($sqlct,$conn) or die("Errore: ".mysql_error()); while ($risct = mysql_fetch_array($execct)) { ?> } }?>