Ciao, prova a usare questo codice:
$categoria = "SELECT * FROM pcategory";
mysql_select_db("cms",$connection);
$sel_categoria=mysql_query($categoria, $connection) or die(mysql_error());
$row_sel_categoria = mysql_fetch_assoc($sel_categoria);
$totalRows_sel_categoria = mysql_num_rows($sel_categoria);
if ($totalRows_sel_categoria > 0) { // Show if recordset not empty
do {
$id = $row_sel_categoria['id'];
$name=$row_sel_categoria['name'];
print '<br />';
print '<b>- ' . $name . ' -</b>';
print '<br />';
$pagine = "SELECT * FROM pages WHERE content=".$id." or puser='".$name."'":
$sel_pagine=mysql_query($pagine, $connection) or die(mysql_error());
$row_sel_pagine = mysql_fetch_assoc($sel_pagine);
$totalRows_sel_pagine = mysql_num_rows($sel_pagine);
if ($totalRows_sel_pagine > 0) { // Show if recordset not empty
do {
$title = $row_sel_pagine['title'];
print '<a href="p/'.$title.'.php">'.$title.'</a>';
} while ($row_sel_pagine = mysql_fetch_assoc($sel_pagine));
} while ($row_sel_categoria = mysql_fetch_assoc($sel_categoria));
} // Show if recordset not empty ?>
if ($totalRows_sel_categoria == 0) { // Show if recordset empty
} // Show if recordset empty
