My code is not working…it won’t update mySQL table and when I put in an integer instead of a variable for the VALUES it only does it once and then never does it again. Please look at my code and let mek now if u can help. I am inserting fields in to my database through changes the user makes through a form.
if (isset($edit) && $edit==“editfilm”) {
echo’You have edited film: '.$title;
echo’
Click here to return to the main page’;
$change_result=“update short_films set”.
“arrange=’”.$_GET[‘arrange’]."’".
“where id =’”.$_GET[‘id’]."’";
$change_result = mysql_query($change,$connect);
}[/php]