<?php
$query1 =
"SELECT titolo, desclunga, link, img, data FROM news WHERE online = 1 GROUP BY data ORDER BY data DESC";
$result = mysql_query($query1) or die(mysql_error());
//<td>Indirizzo</td><td>Cap</td><td>Cittá</td><td>Provincia</td><td>Telefono</td><td>Fax</td></tr>[/b]";
while ($record = mysql_fetch_array ($result)) {
echo "<div id='caratteristichenews'>", $record["data"]," - ",$record["titolo"],"</div>";
echo "Focus on: ", $record["titolo"],"
";
if (empty($record["img"])) {
echo $record["desclunga"],"
","",$record["link"],"
";
} else {
echo "<div id='main-newsimg'>[img]",$record["img"],"[/img]</div>
",$record["desclunga"],"
",$record["link"],"
";
}
} ?>
Rispondi quotando