ciao, quando modifico i dati che sono nel db, la modifica viene eseguita, però mi compare questo errore:
questa è la select di modifica:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.sito.it/include_case2_mat_in_corsi.php on line 39
e questo è il resto:Codice PHP:elseif ($pagina==3){
$sql = "UPDATE a_corsi_materie SET id_corsi='$id_corsi', id_materia1='$id_materia1', id_materia2='$id_materia2', id_materia3='$id_materia3', id_materia4='$id_materia4', id_materia5='$id_materia5', id_materia6='$id_materia6', id_materia7='$id_materia7', id_materia8='$id_materia8', id_materia9='$id_materia9', id_materia10='$id_materia10', id_materia11='$id_materia11' WHERE id_corsi=$id";
mysql_query($sql,$conn) or die (mysql_error() );
$msg = "modifiche effettuate";
}
ecc...Codice PHP:<form enctype="multipart/form-data" name="form" action="<?=$PHP_SELF?>" method="get">
<select name="id_corsi">
<option value="" selected="selected">corso non selezionato</option>
<?php
$query2 = "SELECT * FROM a_corsi ORDER BY nome_corso";
$result2 = mysql_query($query2, $conn);
while($row2 = mysql_fetch_array($result2)) { ?>
<option value="<?=$row2["id_corsi"]?>" <?if ($corso==$row2["id_corsi"]){echo "selected";}?>><?=$row2["nome_corso"]?></option><?
}
?>
</select>
<input type="hidden" name="id" value="<?=$corso?>">
<input type="hidden" name="pagina" value="3">
<input name="submit2" type="submit" class="pulsante" value="modifica">
<?php
$query3 = "SELECT * FROM a_corsi_materie
WHERE id_corsi = $corso";
$result3 = mysql_query($query3, $conn);
$row3 = mysql_fetch_array($result3);?>
<select name="id_materia1">
<option value="" selected="selected">materia non selezionata</option>
<?php
$query4 = "SELECT * FROM a_materie ORDER BY nome_materia";
$result4 = mysql_query($query4, $conn);
while($row4 = mysql_fetch_array($result4)) { ?>
<option value="<?=$row4["id_materie"]?>" <?if ($row3[id_materia1]==$row4["id_materie"]){echo "selected";}?>><?=$row4["nome_materia"]?></option><?
}
?>
</select>
<select name="id_materia2">
<option value="" selected="selected">materia non selezionata</option>
<?php
$result4 = mysql_query($query4, $conn);
while($row4 = mysql_fetch_array($result4)) { ?>
<option value="<?=$row4["id_materie"]?>" <?if ($row3[id_materia2]==$row4["id_materie"]){echo "selected";}?>><?=$row4["nome_materia"]?></option><?
}
?>
</select>
</form>
Rispondi quotando
