I get the following error message when I run the script:
Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\www\New Folder (2)\process.php on line 24
I am trying to write the session variables to a table called schools in a table called school_users, this all works when I simply put words in 'here' in the MySQL command part of my script. So this shows its all OK, (the POST values also work), but I think the trouble is when I use this:
$_SESSION['school_name'] in the MySQL command part, that, I think is why I get the error. Help to tell me how to put these in SQL commands or renaming them to $variables or something would be greatly appreciated.
My script is below:
<?php session_start(); // This connects to the existing session ?>
<html>
<head>
<title>process</title>
</head>
<body>
<?php
session_register ("school_name"); // Create a session variable called name
session_register ("postcode"); // Create a session variable called job
session_register ("teacher_name"); // Create a session variable called name
session_register ("email"); // Create a session variable called job
session_register ("password"); // Create a session variable called name
session_register ("num_logins"); // Create a session variable called name
$SESSION['school_name'] = $POST['postcode'];
$SESSION['postcode'] = $POST['postcode'];
$SESSION['techer_name'] = $POST['teacher_name'];
$SESSION['email'] = $POST['email'];
$SESSION['num_logins'] = $POST['num_logins'];
mysql_connect("localhost", "root", "******") or die(mysql_error());
mysql_select_db("school_users") or die(mysql_error());
mysql_query("INSERT INTO schools VALUES ( '$SESSION['school_name']', '$SESSION['postcode']', '$SESSION['techer_name']', '$SESSION['email']', '$_SESSION['num_logins']' )");
?>
</body>
</html>
Thanks for any help.
P.S I am failry new to PHP so the solution is probably very simple.
MC
