[timbaker1991]

Hi been working on this simple code to query a database (I know - PHP forum) and for some reason it suddenly started returing a 500 internal server error and i can't figure out why.

I've re-set the scripting on the server - its only this page that does it as well so don't think its a sole server error?

Heres the code

PHP Code:

<?php

// Connects to your Database

mysql_connect("XXXXXXX") or die(mysql_error());

mysql_select_db("XXXXXX") or die(mysql_error());



//This code runs if the form has been submitted

if (isset($_POST['submit'])) {





$write=$_GET["school"];

$school="subjects_".$write;

$sub=$_GET["subject"];

$member=$_POST['member'];

$teacher=$_GET['teacher'];

$year=$_GET['year'];



mysql_query("UPDATE subjects_sixthform SET teacherfive='$member' WHERE id='$sub'");



}

else

{

header ('staff_edit_staff.php#read=sorry+there+was+an+error+please+try+again');

}

?>

And the form its coming from,

PHP Code:

<form enctype="multipart/form-data" action="excu_staff_edit.php?teacher=teacherfive&school=<?php echo $_GET[school]?>&subject=<?php echo $_GET[subject]?>&year=<?php echo $_GET[year]?>" method="POST">

    <br />

    Change to: <?php include("staff_list.php")?>

    <input type="submit" name="edit" value="Save"></form> 

    <br />

[wirehopper]

header ('location:staff_edit_staff.php#read=sorry+there+w as+an+error+please+try+again');