parse error in php code

Question

I just started php and I want to know how to make this parse error work. This is the error: Parse error: parse error in E:\wamp\www\PHP\create.php on line 22

And here is my code, by the way I'm making a database manipulating system. And I use wampserver and dreamweaver.

            <?php
          include 'E:\wamp\www\PHP\connection.php';

    $IDNUMBER = $_POST['ID'];
    $LNAME = $_POST['Lname'];
    $FNAME = $_POST['Fname'];
    $MNAME = $_POST['Mname'];
    $GRADEYR = $_POST['GradeYr'];
     $ADDRESS = $_POST['Address'];

      if(!$_POST['submit']) {
  echo "please fill out the form";
  header('Location: E:\wamp\www\PHP\main.php');
    } else {

   mysql_query = "INSERT INTO  students (`IDNUMBER`,`LNAME` ,`FNAME` ,`MNAME` ,`GRADEYR` ,`ADDRESS`)
                VALUES (NULL, '$IDNUMBER', '$LNAME', '$FNAME', '$MNAME', '$GRADEYR', '$ADDRESS')") or die(mysql_error());

                echo "User has been added!";
                header('E:\wamp\www\PHP\main.php');


             }

           ?>

Please help, I'm just a beginner in php.

Answer 1

mysql_query = "INSERT ....") or die(...);

You have an extra closing ")"; Remove it from there.

The code shoult look like mysql_query("INSERT ....") or die(...);

if you want to insert something into the DB:)

Answer 2

mysql_query = "...

should be

mysql_query(...)

Answer 3

'$ADDRESS')") you have an extra bracket here. Check it dude.

Answer 4

You also likely forgot to escape / sanitize the user input...

If the name or an address contains an ' you might have issues