Buonasera a tutti!
E' da 2 giorni che mi sto scervellando su questo script.
In pratica apro la pagina, scelgo il canale da gestire e passa la variabile id ricaricando la pagina assegnando a Chanale la variabile id.
Purtroppo ricarica la pagina (nella barra indirizzo vedo anche l'assegnazione corretta della variabile) ma non vengono caricati i dati dal db.
Potete aiutarmi?
Questo è lo script:
codice:
<?php include "../config/config.inc.php"; ?>
<?php
$connessione = mysql_connect ("$db_host", "$db_login", "$db_pass");
$db = mysql_select_db("$database", $connessione);
if ($id=="") {
$sql = "Select * from chans order by Chanale asc";
$selezione = mysql_query($sql, $connessione);
$Elenco.="<option value=''>--- Seleziona un Canale ---</option>";
while ($riga = mysql_fetch_array($selezione)) {
$id_Canale=$riga['Chanale'];
$Elenco.="<option value='Amministrazione.php?Sezione=Canale_Edit_Form.php&id=$id_Canale'>$id_Canale</option>";
}
}
if ($id!="") {
$sql = "Select * from chans where Chanale='$id'";
$selezione = mysql_query($sql, $connessione);
//$Elenco.="<option value=''>--- Seleziona un Canale ---</option>";
$riga = mysql_fetch_array($selezione);
$id_Canale=$riga['Chanale'];
$A=$riga['A'];
$B=$riga['B'];
$C=$riga['C'];
$D=$riga['D'];
$Elenco.="<option value='Amministrazione.php?Sezione=Canale_Edit_Form.php&id=$id_Canale'>$id_Canale</option>";
}
$Elenco.="<option value='#'>--- Seleziona un Canale ---</option>";
?>
<html>
<head>
<title>Form Manage Canali</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/_Styles/base.css" type="text/css">
<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<link href="../base.css" rel="stylesheet" type="text/css">
</head>
<script language="javascript">
<!--
function Mostra_Tutto()
{popup=window.open("../ins/All_News.php","popdialog","height=500, width=600, scrollbars=no, resaziable=1")
popup.focus(); popup.document.close()}
<!--done hiding
//-->
</script>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="Amministrazione.php?Sezione=Canale_EDIT_Mem.php&id=$id_Canale" enctype="multipart/form-data">
<table width="530" border="0" cellspacing="1" cellpadding="0">
<tr valign="middle">
<td width="16" height="18"> </td>
<td colspan="3"><div align="right">
<p > </p>
</div></td>
</tr>
<tr valign="middle">
<td width="16" height="19"> </td>
<td width="120" class="data" >Canale da gestire</td>
<td colspan="2">
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<?php echo $Elenco; ?>
</select>
</td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="3"> </td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" valign="top" bgcolor="#9999FF" class="data"> Sezione
"A"</td>
<td width="196" valign="top" bgcolor="#9999FF" class="data"> </td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" class="bordi">
<input name="A" type="text" class="bordi" id="A" Value="<?php echo $A; ?>">
</td>
<td align="center" bgcolor="#FF6600" class="bordi"> Banner</td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" valign="top" bgcolor="#9999FF" class="data" > </td>
<td valign="top" bgcolor="#9999FF" class="data" > </td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="3" align="center" bgcolor="#FF6600" class="bordi">Banner</td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="3" valign="top" bgcolor="#9999FF" > </td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="3" align="center" bgcolor="#FF6600" class="bordi">Banner</td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" valign="top" bgcolor="#9999FF" class="data"> Sezione
"B"--</td>
<td valign="top" bgcolor="#9999FF" class="data"> Sezione
"C"</td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" bgcolor="#9999FF" class="bordi">
<input name="B" type="text" class="bordi" id="B" Value="<? echo $B; ?>">
</td>
<td bgcolor="#9999FF" class="bordi">
<input name="C" type="text" class="bordi" id="C" Value="<? echo $C; ?>">
</td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" valign="top" bgcolor="#9999FF" class="data"> </td>
<td valign="top" bgcolor="#9999FF" class="data"> </td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" align="center" bgcolor="#FF6600" class="bordi"> Banner </td>
<td align="center" bgcolor="#FF6600" class="bordi">Banner</td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" bgcolor="#9999FF"> </td>
<td bgcolor="#9999FF"> </td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="3" align="center" bgcolor="#FF6600" class="bordi">Banner</td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="2" bgcolor="#9999FF"> </td>
<td bgcolor="#9999FF"> </td>
</tr>
<tr valign="middle">
<td height="18"> </td>
<td colspan="3" valign="top" bgcolor="#9999FF"> <span class="data"> Sezione
"D"--</span></td>
</tr>
<tr valign="middle">
<td height="18" class="mini"> </td>
<td colspan="3" class="bordi">
<input name="D" type="text" class="bordi" id="D" Value="<? echo $D; ?>">
</td>
</tr>
<tr valign="middle">
<td height="16"> </td>
<td colspan="3" height="16">
<div align="right">
<input type="hidden" name="id" value="<? echo $id; ?>">
<a href="../ins/All_News.php" target="_blank" onclick=Mostra_Tutto()>Vedi
Tutte le Notizie</a></div>
</td>
</tr>
<tr valign="middle" align="center">
<td height="33" colspan="4">
<input type="submit" name="Submit" value="Archivia Modifiche" class="bordi">
<input type="reset" name="Submit2" value="Cancella" class="bordi">
</td>
</tr>
<tr>
<td height="1"></td>
<td></td>
<td width="77"></td>
<td></td>
</tr>
</table>
</form>
</body>
</html>