Just hit the database and ask for it...

[...]
<?
if( $article>0 )
{
// get this article topic
$local_result=mysql_query("select topic from ARTICLEtopic where article=$article LIMIT 0,1");

if($localrow=@mysql_fetch_object($local_result))
// is there at least one topic for this article?
{
$mytopic=$localrow->topic;

// want to get the "subject" name also?
$local_result=mysql_query("select legenda =from ARTICLEtopictxt where serial=$mytopic LIMIT 0,1");

if($localrow=@mysql_fetch_object($local_result)) // get the topic name
{
$topicname=$localrow->legenda;
}
}
}
?>
[...]

Then you can do something like:

[...]
<title>SIC.Online - <? if ($article>0) print "$topicname"; else print"$area_name"; ?></title>
[...]

Or something like:

[...]
if($mytopic=1) { $bgcolor="#00000"; [... more stuff per tematic area ...] }
else if ($mytopic=2) { $bgcolor="#00000"; [... more stuff per tematic area ...] }
[...]

And so on...

Note:

To get a menu and print sub section try something like

<?

# prints sub areas
$query = mysql_query ("SELECT id, name FROM areas WHERE parent=$id ORDER BY weight");

if (mysql_num_rows($query)) {
?>
<table border=0 cellspacing=0 cellpadding=0 bgcolor=#FFFFFF align="center">
<tr>
<td>
<table border=0 cellspacing=1 cellpadding=0 align="center">
<tr bgcolor=#FFFFFF>
<?
$num_areas = mysql_num_rows($query);
$largura = 100/$num_areas;
$itens_barra = 1;

while (list($child_id, $child_name) =mysql_fetch_row($query)) {

$child_name = htmlentities (StripSlashes($child_name));

print "<td>".
"<font color=#FF9900 face='Verdana, Arial, Sans-Serif' size=1>".
"<b><a href='index.php?id=$child_id'>$child_name</a></b>".
"</font></td>";

if ($itens_barra!=$num_areas) { print "<td
align=center> | </td>";}
if ($itens_barra==5) { print "</tr><tr
bgcolor=#FFFFFF>"; $itens_barra = 1; }
else $itens_barra ++;
}

?>
</tr>
</table>
</td>
</tr>
</table>
<?
}
?>

The tables are only for obtain the output. You can edit the html code to obtain another look.

You need to create an object listing a certain number of articles for each subject.

In your interface use something like:

<?
if( $article>0 )
{
// get this article topic
$local_result=mysql_query("select topic from ARTICLEtopic where article=$article LIMIT 0,1");
if($localrow=@mysql_fetch_object($local_result)) // is there at least one topic for this article?
{
$mytopic= $localrow->topic;

// make a topic relate to a certain page object...
if($mytopic==1) { $headline=12;} // news - just the last 10 titles
if($mytopic==2) { $headline=23;} // some of Gods greatest mistakes - just the last 10 titles
if($mytopic==3) { $headline=23;} // some of Gods greatest mistakes - just the last 10 titles
if($mytopic==4) { $headline=24;} // more of Gods greatest mistakes - just the last 10 titles
if($mytopic==5) { $headline=25;} // who is this God person anyway? - just the last 10 titles
if($mytopic==7) { $headline=44;} // sex in the ants world,
// etc...

// show the page object containing the related items...
include"object/show.php";
}
}
?>

This is pseudo code (I have not tested it) but should be pretty close to real thing...

Put something like this in the Interface program:

[...]
$headline=53; # the number of your page object
include "object/show.php"
[...]

for articles use:

[...]
$article=53; # the number of your page object
include "article/show.php"
[...]


You can combine an unlimited number of objects in the same page...

Note: