include('config.php');
$nome = Array();
$nome_red = ucwords(str_replace("_", " ", $_GET['pub']));
$sql_s = "SELECT * FROM sg_pub WHERE nome_red='".$nome_red."' AND visual='YES' ORDER BY ordine";
$result_s = mysql_query($sql_s);
$righe_s = mysql_num_rows($result_s);
for($i = 0; $i < $righe_s; $i++)
{
$id = mysql_result($result_s, $i, 'id');
$nome[$id] = mysql_result($result_s, $i, 'nome_'.$lang);
if($nome[$id] == '')
{
if($lang == 'eng')
{
$nome[$id] = mysql_result($result, $i, 'nome_ita');
}
}
}
// echo '
include('footer.php');
?>