INSERT query problems

[Agreaves]

Can somebody tell me whats wrong with this insert query, I keep getting an error message.

<?php

$sql2 = "INSERT INTO members (firstname, lastname, state, email, username, password, signupdate) VALUES ('$firstname', '$lastname', '$state', '$email', '$username', '$password', NOW()";
?>

[bradgrafelman]

You're missing a closing ')' for the VALUES section.

In the future, it would probably be beneficial if you posted the error message as well (that way we don't have to guess as to what both the problem and the solution might be).

[Agreaves]

I did put it in and still got this error message after testing,

<?php
$sql2 = "INSERT INTO members (firstname, lastname, state, email, username, password, signupdate) VALUES ('$firstname', '$lastname', '$state', '$email', '$username', '$password', NOW())"; 
?> 

Fatal error: Unable to perform insert query in C:\xampp\htdocs\register.php on line 34

[bradgrafelman]

Well that's not an error generated by PHP, so I'd say modify register.php so that it outputs (or logs) the actual MySQL error message.

[Agreaves]

Take a look at the variables, maybe that could be the cause of the problem,

<?php
$firstname = mysqli_real_escape_string($conn, trim($_POST['firstname']));
	$lastname = mysqli_real_escape_string($conn,trim($_POST['lastname']));
	$state = mysqli_real_escape_string($conn, $_POST['state']);
	$email = mysqli_real_escape_string($conn, $_POST['email']);
	$username = mysqli_real_escape_string($conn, trim($_POST['username']));
	$password = mysqli_real_escape_string($conn, trim(sha1(($_POST['password']))));
?>

[bradgrafelman]

If the variables are all being escaped, then I can't really think of any problems they would cause.

Print out the SQL query as well as the error message returned by MySQL and post both here for us to see.