I do hope you can help
I am creating a new user using the email as the username field. all is going okay except for a syntax error from Mysql
The error reads like this:
You have an error in your MySQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') values ( 'test@jetpets.com.au' at line 2
and Here is the code
<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php
include_once("includes/form_functions.php");
// START FORM PROCESSING
if (isset($_POST['submit'])) { // Form has been submitted.
$errors=array();
// perform validations on the form data
$required_fields = array('Email', 'password','FirstName', 'LastName', 'Permission', 'Location');
$errors = array_merge($errors, check_required_fields($required_fields, $_POST));
$fields_with_lenghts= array('Email' =>80, 'password' => 50, 'Permission' =>20, 'Location' =>30,
'FirstName'=>50, 'LastName' =>60 );
$errors = array_merge($errors, check_max_field_lengths($fields_with_lenghts, $_POST));
// Username is email address
$email=trim(mysql_prep($_POST['Email']));
$password=trim(mysql_prep($_POST['password']));
$hashed_password = sha1($password);
$location=trim(mysql_prep($_POST['Location']));
$firstname=trim(mysql_prep($_POST['FirstName']));
$lastname=trim(mysql_prep($_POST['LastName']));
$permission=trim(mysql_prep($_POST['Permission']));
if (empty($errors)){
$query = "INSERT INTO cssu(
Email, hashed_password, Location, FirstName, LastName, Permission,)
values (
'{$email}', '{$hashed_password}', '{$location}', '{$firstname}', '{$lastname}', '{$permission}')";
$result = mysql_query($query, $connection);
if ($result){
$message = "The User was successfully Created.";
}else {
$message ="The user could not be created";
$message .="</br> />" . mysql_error();
}
}else {
if (count($errors)==1){
$message ="There was 1 error in the form";
} else {
$message = "There were " . count($errors) . "errors in the form";
}
}
} else { // Form has not been submitted. Username is email address
$email = "";
$password = "";
$location = "";
$firstname ="";
$lastname = "";
$permission = "";
}
?>
Can anyone please help
Jim
