Eccolo:
Codice PHP:
<?
$query = "SELECT ID_areesx,Titolo_areesx,AreaSuperiore,Link FROM areesx WHERE AreaSuperiore='1'";
$result = mysql_query($query, $db);
$tot = mysql_num_rows($result);
$limite = round($tot/2);
$query = "SELECT ID_areesx,Titolo_areesx,AreaSuperiore,Link FROM areesx WHERE AreaSuperiore='1' ORDER BY Titolo_areesx LIMIT 0, $limite";
$result = mysql_query($query, $db);
echo "<td>\n";
while ($rows = mysql_fetch_array($result)) {
$link = $rows["Link"];
if ($link=="") {
echo "[img]images/indice2.gif[/img] <a href=area.php?ID_areesx=".$rows["ID_areesx"].">".$rows["Titolo_areesx"]."</a>
";
} else {
echo "[img]images/indice2.gif[/img] [url=".$link."]".$rows["Titolo_areesx"]."[/url]
";
}
}
echo "</td>\n";
$query = "SELECT ID_areesx,Titolo_areesx,AreaSuperiore,Link FROM areesx WHERE AreaSuperiore='1' ORDER BY Titolo_areesx LIMIT $limite, $limite";
$result = mysql_query($query, $db);
echo "<td>\n";
while ($rows = mysql_fetch_array($result)) {
$link = $rows["Link"];
if ($link=="") {
echo "[img]images/indice2.gif[/img] <a href=area.php?ID_areesx=".$rows["ID_areesx"].">".$rows["Titolo_areesx"]."</a>
";
} else {
echo "[img]images/indice2.gif[/img] [url=".$link."]".$rows["Titolo_areesx"]."[/url]
";
}
}
echo "</td>\n";
?>
Grazie comunque