non mi era sfuggito, credevo fosse concettuale
--------------------script del video----------------------------------------------
case 'select':
if ($row['nome_campo_form']=="cod_cli") {
$query1 = "select cod_cli from clienti";
$dbResult1 = mysql_query($query1, $db);
?>
<tr>
<td>
<?=$row['desc_campo_form']; ?>
</td>
<td>
<select name="<?=$row['nome_campo_form']; ?>"><option value ='scegli'>scegli</option>
<?php
while ($row1 = mysql_fetch_array($dbResult1)) {
echo"<option value=".$row1['cod_cli'].">".$row1['cod_cli']."</option>";
}
?>
</select>
</td>
</tr>
<?php
}
if ($row['nome_campo_form']=="rag_soc_cli") {
$query2 = "select rag_soc_cli from clienti order by rag_soc_cli";
$dbResult2 = mysql_query($query2, $db);
?>
<tr>
<td>
<?=$row['desc_campo_form']; ?>
</td>
<td>
<select name="<?=$row['nome_campo_form']; ?>"><option value ='scegli'>scegli</option>
<?php
while ($row2 = mysql_fetch_array($dbResult2)) {
echo"<option value=".$row2['rag_soc_cli'].">".$row2['rag_soc_cli']."</option>";
}
?>
</select
-------------------------secondo script che deve estrarre i dati dal db-------------------------
<form method="POST" action="inse2_old_cli.php">
<?php
$db = mysql_connect($host, $user, $password) or die("impossibile connettersi al server host");
mysql_select_db($database, $db) or die ("impossibile connettersi al database $database");
if ($cod_cli !== 'scegli') {
$query3 = "select * from clienti where cod_cli = '$cod_cli'";
$dbResult3 = mysql_query($query3, $db);
while ($row3 = mysql_fetch_array($dbResult3)) {
$rag_soc_cli = $row3['rag_soc_cli'];
$indir_cli = $row3['indir_cli'];
$tel_cli = $row3['tel_cli'];
$fax_cli = $row3['fax_cli'];
}
}
if ($rag_soc_cli !== 'scegli') {
$query4 = "select * from clienti where rag_soc_cli = '$rag_soc_cli'";
$dbResult4 = mysql_query($query4, $db);
while ($row4 = mysql_fetch_array($dbResult4)) {
$cod_cli = $row4['cod_cli'];
$indir_cli = $row4['indir_cli'];
$tel_cli = $row4['tel_cli'];
$fax_cli = $row4['fax_cli'];
echo("codcli: $cod_cli");
echo("indircli: $indir_cli_cli");
echo("telcli: $tel_cli");
echo("faxcli: $fax_cli");
}
}