Sapete dirmi perchè non stampa nulla ed i record ci sono?
Codice PHP:
<table width="650" border="0" cellspacing="0" cellpadding="10">
<tr>
<td class="text" height="2">
<?php
require "luix_config.php";
if (!isset($d))
$d="0";
if (!isset($f))
$f=$dv_guest_page;
$db = mysql_connect("$lx_host", "$lx_login", "$lx_pass") or
die("Database non esiste");
mysql_select_db("$lx_base",$db);
$query = "SELECT * FROM NEWS ORDER BY date DESC LIMIT ".$d.", ".$dv_guest_page."";
$result = mysql_query($query) or die ("Impossible</p>");
$nb_result = mysql_num_rows($result);
$query_nb = "SELECT * FROM NEWS";
$result_nb = mysql_query($query_nb) or die ("");
$nb_result_nb = mysql_num_rows($result_nb);
while ($row = mysql_fetch_array($result)) {
$Titolo = $row[Titolo];
$Head = $row[Head];
$Body = $row[Body];
$date = time();
?>
<table width="50%" border="0" cellspacing="0" cellpadding="3" align="center">
<tr bgcolor="#CCCCCC">
<td align="left" bgcolor="#CCCCCC">
<?php echo $Titolo ?>
</a>
</td>
<td width="200" bgcolor="#CCCCCC" align="right">
<?php echo $Head ?></td>
</tr>
<tr bgcolor="#CCCCCC">
<td bgcolor="#DDDDDD" colspan="2"><?php $Body ?></td>
</tr>
<tr bgcolor="#CCCCCC">
<td bgcolor="#DDDDDD" colspan="2"><?php $date ?>
</td>
</tr>
</table>
<? }
mysql_close($db);
echo "<center>\n";
if ($d != "0") {
$d_new1 = $d-$dv_guest_page;
$f_new1 = $d;
echo "<a href=\"news.php?d=$d_new1&f=$f_new1\"><< Pagina Precedente</a> | \n";
}
$nb_pages = intval($nb_result_nb/$dv_guest_page)+1;
if ($nb_pages > "1") {
for ($i=0;$i<$nb_pages;$i++) {
if (isset($d_page))
$d_page = $d_page+$dv_guest_page;
else
$d_page = "0";
$f_page = $f_page+$dv_guest_page;
$num_page = $i+1;
if ($d==$d_page)
echo $num_page."\n";
else {
if ($d_page < $nb_result_nb)
echo "<a href=\"news.php?d=$d_page&f=$f_page\">".$num_page."</a> \n";
}
}
}
if ($f < $nb_result_nb) {
$d_new2 = $f;
$f_new2 = $f+$dv_guest_page;
echo "| <a href=\"news.php?d=$d_new2&f=$f_new2\">Pagina Avanti >></a>\n";
}
?>
</td>
</tr>
</table>
Grazie. perfavore .