select con valore scelto

[prinzart]

<?php 
$sql = mysql_query("SELECT * FROM a_corsi ORDER BY nome_corso") or die(mysql_error()); 
?> 

<?
if ($pagina==1){
$sql = "INSERT INTO a_corsi_materie (id_corsi)
VALUES ('$id_corsi')";
mysql_query($sql, $conn) or die ($sql);
$msg = "corso inserito nel database";
}

elseif ($pagina==2){
    $sql = "SELECT nome_corso FROM a_corsi WHERE id_corsi=$corso";
    $result = mysql_query($sql,$conn);
    $row = mysql_fetch_array($result);
} 

elseif ($pagina==3){
$sql = "UPDATE a_corsi_materie SET id_corsi='$id_corsi' WHERE id_corsi=$id";
mysql_query($sql,$conn) or die (mysql_error() );
$msg = "modifiche effettuate";
} 

?>

<?php 
  $_GET['pagina'] = (isSet($_GET['pagina']) && ($_GET['pagina'] > 0)) ? $_GET['pagina'] : 0; 
  switch ($_GET[pagina]) 
  { 
   case 2: $pagina = 'include_case2_mat_in_corsi.php'; break; 
   case 3: $pagina = 'include_case2_mat_in_corsi.php'; break;    
   default: $pagina = 'include_case1_mat_in_corsi.php'; 
  } 
  include($pagina); 
?>

ora il codice della pagina include_case1_mat_in_corsi.php

<form enctype="multipart/form-data" name="form" action="<?=$PHP_SELF?>" method="post">
<table width="650" border="0" cellspacing="0" cellpadding="0">
      <tr>
    <td width="113" height="33"><span class="testo_grigio_bold">nome corso </span></td>
    <td width="162" align="right">

 <select name="id_corsi"> 
<option value="" selected="selected">seleziona corso</option> 
<?php 
//compila dinamicamente la select 
while($row = mysql_fetch_object($sql)) { 
  echo "<option value=\"$row->id_corsi\">$row->nome_corso</option>\n"; 
} 
?> 
</select>

</td>
    <td width="100"></td>
    <td colspan="2"><input type="hidden" name="pagina" value="1">
          <input name="submit" type="submit" class="pulsante" value="inserisci">
<?
    if ($msg){?>
      <span class="testo_viola_bold">
      <?=$msg?>
      </span>
      <?
        }?>
</td>
    </tr>
<tr>
    <td height="1" colspan="5" valign="top" bgcolor="BF9BB5"></td>
    </tr>
      <tr>
        <td height="41" colspan="2"><span class="testo_viola_bold">elenco corsi</span></td>
        <td></td>
    <td></td>
<td></td>
    </tr>
    </table>
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td height="1" colspan="4" bgcolor="BF9BB5"></td>
    </tr>
                              <?
                          $i=1;
                        $sql = mysql_query("SELECT * FROM a_corsi ORDER BY nome_corso") or die(mysql_error());
                        while($row=mysql_fetch_array($sql)){
                            if ($i==1){ echo "<tr>";} ?>
              <td height="41" width="216">
<span class="testo_grigio_bold"><a href="<?=$PHP_SELF?>?corso=<?=$row[id_corsi]?>&pagina=2">[img]../images/menu_triangolo.gif[/img]
      <?=$row['nome_corso']?></a></span>
</td>
                  <?
                            if ($i==3){
                                echo "<td width=\"2\"></td></tr><tr>
    <td height=\"1\" colspan=\"4\" bgcolor=\"BF9BB5\"></td>
    </tr>";
                                $i=0;
                            }
                             $i++;
                        }?>
                          </table>
</form>

ora il codice della pagina include_case2_mat_in_corsi.php

<form enctype="multipart/form-data" name="form" action="<?=$PHP_SELF?>" method="get">
<table width="650" border="0" cellspacing="0" cellpadding="0">
      <tr>
    <td width="113" height="33"><span class="testo_grigio_bold">nome corso </span></td>
    <td width="162" align="right">


<select name="id_corsi"> 
<?php 
$query = "SELECT * FROM a_corsi"; 
$result50 = mysql_query($query, $conn); 
while($row = mysql_fetch_array($result50)) { 
$var=$_GET[id_corsi]; 
if ($row[id_corsi]==$var) echo "<option value=\"$row[id_corsi]\" selected>".$row[nome_corso]."</option>"; 
else echo "<option value=\"$row[id_corsi]\">corso non selezionato</option>"; 
} 
?> 
</select> 



</td>
    <td width="100"></td>
    <td colspan="2"><input type="hidden" name="id" value="<?=$corso?>">
         <input type="hidden" name="pagina" value="3">
         <input name="submit2" type="submit" class="pulsante" value="modifica">
<?
    if ($msg){?>
      <span class="testo_viola_bold">
      <?=$msg?>
      </span>
      <?
        }?>
</td>
    </tr>
<tr>
    <td height="1" colspan="5" valign="top" bgcolor="BF9BB5"></td>
    </tr>
      <tr>
        <td height="41" colspan="2"></td>
        <td></td>
    <td></td>
<td></td>
    </tr>
    </table>
</form>