include('config.php');
$aaa = Array();
$sql_s = "SELECT * FROM sg_pub WHERE visual='YES'";
$result_s = mysql_query($sql_s);
$righe_s = mysql_num_rows($result_s);
for($i = 0; $i < $righe_s; $i++)
{
$nome = mysql_result($result_s, $i, 'nome_red');
$aaa[] = ucwords($nome);
}
$aaa = array_unique($aaa);
sort($aaa);
//
$a = $aaa;
$aaa = Array();
$aaa[0] = $a[1];
unset($a[1]);
$aaa[1] = $a[2];
unset($a[2]);
$aaa[2] = $a[0];
unset($a[0]);
$x = 3;
sort($a);
for($i = 0; $i < count($a); $i++)
{
$aaa[$x] = $a[$i];;
$x++;
}
//style="float: left; width: 80%; height: 265px; position: relative; overflow: hidden; overflow-y: scroll;"
echo '
';
?>
include('footer.php');
?>