vi mostro il code
- Codice: Seleziona tutto
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Documento senza titolo</title>
</head>
<body>
<?
$connessione=mysql_connect("localhost","root","");
$db=mysql_select_db("nicholaus_prova");
$query="SELECT * FROM `nich_content` WHERE sectionid =9 GROUP BY catid";
$riga1=mysql_query($query);
$num=mysql_num_rows($riga1);
echo($num);
?>
<table width="100%" align="center" border="1"><tr>
<?
$j=0;
for ($i=1;$i<=$num;$i++){
$query="SELECT * FROM `nich_content` WHERE sectionid =9 order by catid asc";
$record=mysql_query($query);
$riga=mysql_fetch_array($record);
$id=$riga['id'];
$titolo=$riga['title_alias'];
$intro=$riga['introtext'];
$k=$i;
$l=$i/3;
if (is_int($l)== true){ //le ultime td di ogni riga
$query="SELECT * FROM `nich_content` WHERE sectionid =9 order by catid asc";
$record=mysql_query($query);
$riga=mysql_fetch_array($record);
$id=$riga['id'];
$titolo=$riga['title_alias'];
$intro=$riga['introtext'];
echo("<td width='228' height='24' align='center'>".$titolo."</td></tr>");
echo("<tr>");
for ($j=1;$j<=3;$j++){
echo("<td height='126' align='center' valign='top'><table width='100%' border='1'><td valign='top' width='114'>foto</td><td width='114'>".$intro."</td></table></td>");
}
echo("</tr>");
$riga=mysql_fetch_array($record);
}else{
$query="SELECT * FROM `nich_content` WHERE sectionid =9 order by catid asc";
$record=mysql_query($query);
$riga=mysql_fetch_array($record);
$id=$riga['id'];
$titolo=$riga['title_alias'];
$intro=$riga['introtext'];
echo("<td width='228' height='24' align='center' border='4'>".$titolo."</td>");
}
$riga=mysql_fetch_array($record);
}
?>
</tr>
</table>
</body>
</html>
ho anche provato ad inserire dei while $riga=mysql_fetch_array(record)) ma il risultato non cambia....help![/code]