Ho questa pagina che mi mostra i titoli delle news estratti dal mio DB.
Come faccio a far si che mi visualizzi solo gli ultimi 5 e non tutti? Grazie e scusate la banalità della domanda, ma sono alle prime armi.
<html>
<head>
<title>:: ESPN NFL Italia ::</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
</head>
<body bgcolor="#CCCCCC" text="#333333" link="#CC0000" vlink="#CC0000" alink="#CC0000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="750" border="0" cellpadding="0" cellspacing="0">
<tr align="center" valign="baseline" bgcolor="#999999">
<td height="59" colspan="6">[img]testata.jpg[/img]</td>
</tr>
<tr>
<td width="3" valign="top" bgcolor="#000000"></td>
<td width="135" valign="top" bgcolor="#CCCCCC">
<iframe name="main" src="menu.php" width="138" height="311" scrolling="no" frameborder="0">
<span class="Stile1"><font color="#CC3333">_<span class="Stile3">_<font size="2" face="Verdana, Arial, Helvetica, sans-serif">Il
tuo browser non supporta gli Iframe.</font></span></font></span></iframe></p>
</td>
<td width="458" align="center" valign="top" bgcolor="#FFFFFF">
<table width="450" border="0" cellpadding="0" cellspacing="2">
<tr bgcolor="#666666">
<td height="3" colspan="2"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><font color="#FFCC00">
</font></font></td>
</tr>
<tr>
<td height="20"><font color="#CC0000" size="2" face="Verdana, Arial, Helvetica, sans-serif">::</font></td>
<td height="20"><font color="#CC0000" size="2" face="Verdana, Arial, Helvetica, sans-serif">Ultime
notizie: </font></td>
</tr>
<tr>
<td width="14" rowspan="2" valign="top"></td>
<td width="435" valign="top">
<?php
include("inc.php");?>
<?
$sql = "SELECT * FROM `news` order by id desc";
if ($result = mysql_query ("$sql")){
while ($row=mysql_fetch_array ($result)) {
?><table width="450" height="27" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><font color="#CC0000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000000"><? echo $row[gg]; ?>/<? echo $row[mm]; ?>/<? echo $row[yyyy]; ?>:</font>
<? echo $row[titolo]; ?></font></td>
</tr>
<tr>
<td height="2" bgcolor="#CCCCCC"></td>
</tr>
</table> <?
}
}
mysql_close($link);
?>
<font color="#CC0000" size="1" face="Verdana, Arial, Helvetica, sans-serif"></font></p>
<font color="#CC0000" size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font></p></td>
</tr>
<tr>
<td valign="top"></td>
</tr>
</table>
<table width="450" border="0" cellspacing="2" cellpadding="0">
<tr>
<td height="2" bgcolor="#666666"></td>
</tr>
</table>
</td>
<td width="4" valign="top" bgcolor="#333333">
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</td>
<td width="147" align="center" valign="top" bgcolor="#FFFFFF">
<table width="120" border="0" cellpadding="0" cellspacing="0">
<tr align="center">
<td height="40" colspan="4">[img]afc_piccolo.jpg[/img]</td>
</tr>
<tr>
<td width="30" height="30">[img]caschi/piccoli/patriots_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/jets_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/steelers_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/ravens_smL.jpg[/img]</td>
</tr>
<tr>
<td width="30" height="30">[img]caschi/piccoli/colts_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/jaguars_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/broncos_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/chargers_smL.jpg[/img]</td>
</tr>
<tr>
<td width="30" height="30">[img]caschi/piccoli/bills_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/dolphins_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/bengals_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/browns_smL.jpg[/img]</td>
</tr>
<tr>
<td width="30" height="30">[img]caschi/piccoli/texans_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/titans_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/chiefs_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/raiders_smL.jpg[/img]</td>
</tr>
<tr align="center">
<td height="40" colspan="4">[img]nfc_piccolo.jpg[/img]</td>
</tr>
<tr>
<td width="30" height="30">[img]caschi/piccoli/eagles_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/giants_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/packers_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/vikings_smL.jpg[/img]</td>
</tr>
<tr>
<td width="30" height="30">[img]caschi/piccoli/falcons_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/saints_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/seahawks_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/rams_smL.jpg[/img]</td>
</tr>
<tr>
<td width="30" height="30">[img]caschi/piccoli/cowboys_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/redskins_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/bears_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/lions_smL.jpg[/img]</td>
</tr>
<tr>
<td width="30" height="30">[img]caschi/piccoli/bucs_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/panthers_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/cardinals_smL.jpg[/img]</td>
<td width="30" height="30">[img]caschi/piccoli/49ers_smL.jpg[/img]</td>
</tr>
</table>
<table width="125" height="125" border="0" cellpadding="0" cellspacing="0">
<tr>
<td></td>
</tr>
</table>
</p></td>
<td width="3" valign="top" bgcolor="#333333"></td>
</tr>
<tr align="center" valign="middle" bgcolor="#666666">
<td height="70" colspan="6"><table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<?php
include("inc.php");?>
<?
$sql = "SELECT * FROM `index` where id = '1' order by id asc";
if ($result = mysql_query ("$sql")){
while ($row=mysql_fetch_array ($result)) {
?><td><div align="center"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><? echo $row[copyright]; ?></font></div></td>
</tr>
</table>
</td>
<?
}
}
mysql_close($link);
?>
</tr>
</table>
</body>
</html>
Rispondi quotando
