include ("config.inc.php"); include ("inc/sql.scr"); include ("inc/txtmanip.scr"); $db = mysql_connect($db_host, $db_user, $db_password); if ($db == FALSE) die ("prao2::Err conn. Chk parms in config.inc.php"); mysql_select_db($db_name, $db) or die ("prao2::Err dbselect. Chk parms in config.inc.php"); $ao=(isset($_GET['ao'])?$_GET['ao']:$_POST['ao']); // ;-) /*************************************************** * Aggiornamento counter ***************************************************/ $qry="UPDATE premi SET prm_clk=prm_clk+1 WHERE prm_ID='".$ao."' "; //echo $query. "
"; $res=executequery($qry,0,1); /***************************************** * recupero i dati relativi all'ente ed al premio *****************************************/ $sql = "SELECT prm_ente, prm_descr, prm_note FROM premi WHERE prm_ID=$ao"; //echo $sql, "
"; $ris = @mysql_query($sql, $db) or die("prao2::1::IMPSSBL"); while($riga=mysql_fetch_array($ris)) { $ent = $riga['prm_ente']; $prm = $riga['prm_descr']; $prmnote = $riga['prm_note']; } $metacomplex="premio ".$prm." ".$ent; /***************************************** * recupero altre categorie *****************************************/ $lst = ""; $sent = addslashes($ent); $sql = "SELECT prm_ID, prm_descr FROM premi WHERE ((prm_ente='$sent') AND (prm_ID!=$ao))"; //echo $sql, "
"; $ris = @mysql_query($sql, $db) or die("prao2::2::IMPSSBL"); while($riga=mysql_fetch_array($ris)) { $pid = $riga['prm_ID']; $lst .= ($lst==""?"":", ")."".$riga['prm_descr'].""; } /***************************************** * *****************************************/ $j=0; $blocco = ""; $elenco=""; ?> Albo d'oro BigCharlie C.G.S. Vincenzo Cimatti"; echo "

BigCharlie

"; echo "

Visualizzazione contributi disponibili nella locale base di dati.


"; echo "

Albo d'oro della categoria ".$prm." nella storia del premio ".$ent.".

"; if ($prmnote) echo $prmnote."
"; echo $elenco; echo $elelink; if ($lst) echo "

(Le altre categorie del $ent sono: ".$lst.")

"; ?>


a cura di Webmaster