","

",$info[3]); $info[3] = strip_tags($info[3],"
"); echo '

'.$info[1].'

'.$info[2].'


'.$info[3].'

'; //LOGO $sql2 = "SELECT name FROM image WHERE realiz_id = $info[0] AND type = 'logo'"; $res2 = mysql_query($sql2,$conn); $info2 = mysql_fetch_row($res2); if($info2) { while($info2) { $file = explode(".", $info2[0]); if($file[1] == 'jpg' || $file[1] == 'gif' || $file[1] == 'png') echo ' '; $info2 = mysql_fetch_row($res2); } } //IMMAGINE ASSOCIATA $sql3 = "SELECT name FROM image WHERE realiz_id = $info[0] AND type = 'ass'"; $res3 = mysql_query($sql3,$conn); $info3 = mysql_fetch_row($res3); if($info3) { echo '

Allegato:
'; while($info3) { $file = explode(".", $info3[0]); if($file[1] == 'jpg' || $file[1] == 'gif' || $file[1] == 'png') echo '
'; else echo ''.$info3[0].'

'; $info3 = mysql_fetch_row($res3); } } echo '

Torna indietro

'; } //TUTTE LE NEWS else { $sql = "SELECT count(*) FROM realiz"; $res = mysql_query($sql,$conn); $info = mysql_fetch_row($res); $num_tot=$info[0]; $numero_pagine=ceil($num_tot/5); $sql = "SELECT id,title_ita,data_evento,text_ita FROM realiz ORDER BY id DESC"; $res = mysql_query($sql,$conn); $info = mysql_fetch_row($res); if(!$info) echo 'non sono presenti referenze'; else echo '
    '; while($info&&$x<$g) { if($x<$i) { $info = mysql_fetch_row($res); $z++; $x++; } else { $info[3] = str_replace("

    ","

    ",$info[3]); $info[3] = strip_tags($info[3],"
    "); //----------- $position = 100; $post = strip_tags($info[3]); $post = substr($post,0,$position); echo '
  • '.$info[1].'

    '.$info[2].'


    '.$post.'

    '; $sql2 = "SELECT name FROM image WHERE realiz_id = $info[0] AND type = 'logo'"; $res2 = mysql_query($sql2,$conn); $info2 = mysql_fetch_row($res2); if($info2) { while($info2) { $file = explode(".", $info2[0]); if($file[1] == 'jpg' || $file[1] == 'gif' || $file[1] == 'png') echo ' '; $info2 = mysql_fetch_row($res2); } } echo '

    leggi tutto...

    '; //----------- echo '
  • '; $info = mysql_fetch_row($res); $z++; $x++; $i++; } } echo '

'; //DIVISIONE IN PAGINE echo "

"; if($numero_pagine!=0) echo 'Pagina:  '; for($i=0;$i<$numero_pagine;$i++) { $j=$i+1; if($i==$pag) echo ''.$j.'   '; else echo ''.$j.'   '; } echo "
"; //--------------------- } ?>