Codice PHP:
$regione = "Lombardia";
$sqlTot = "SELECT * FROM webcam WHERE regione = '".$regione."'";
$queryTot = mysql_query($sqlTot);
if(mysql_num_rows($queryTot)==0){
echo "Nessuna WebCam Rilevata";
}else{
while ($resultTot = mysql_fetch_array($queryTot)) {
$webcam = "";
$webcam .= "<div style=\"width:20%; float:left; font-family:Verdana; font-size:10px; text-align:center;\">";
$webcam .= "
<a href=\"http://www.webcam.sciclub.it/webcam-montagna.php?id=$resultTot[id]\" title=\"$resultTot[imgalt]\"><img src=\"$resultTot[imgurl]\" width=\"120px\" height=\"100px\" alt=\"$resultTot[imgalt]\" border=\"0\" /></a></p>";
$webcam .= "<a href=\"http://www.webcam.sciclub.it/webcam-montagna.php?id=$resultTot[id]\" title=\"$resultTot[imgalt]\">$resultTot[h2]</a>";
$webcam .= "
";
$webcam .= "</div>";
echo $webcam;
}
}
oppure
Codice PHP:
$regione = "Lombardia";
$sqlTot = "SELECT * FROM webcam WHERE regione = '".$regione."'";
$queryTot = mysql_query($sqlTot);
if(mysql_num_rows($queryTot)==0){
echo "Nessuna WebCam Rilevata";
}else{
while ($resultTot = mysql_fetch_array($queryTot)) {
echo "<div style=\"width:20%; float:left; font-family:Verdana; font-size:10px; text-align:center;\">";
echo "
<a href=\"http://www.webcam.sciclub.it/webcam-montagna.php?id=".$resultTot['id']."\" title=\"".$resultTot['imgalt']."\"><img src=\"".$resultTot['imgurl']."\" width=\"120px\" height=\"100px\" alt=\"$resultTot[imgalt]\" border=\"0\" /></a></p>";
echo "<a href=\"http://www.webcam.sciclub.it/webcam-montagna.php?id=$resultTot[id]\" title=\"".$resultTot['imgalt']."\">".$resultTot['h2']."</a>";
echo "
";
echo "</div>";
}
}
Rispondi quotando