Ok I am writing a new member script and I have the following code.. but on sbmit everythin checks out except line 118 has a prase error?

PHP Code:

$query = "INSERT INTO user_main(email_address, username, password, signup_date, email2, email) VALUES('$email_address', '$username', '$db_password', $signup_date, '$email2', '$email')"; 


its kinda important oviosly its my acctualy submit to mySQL part and I donno whats wrong...

Chroder? lol

you have to add a ; behind every line

OMG...
Well I feel dumb...
I think that was the one stupid minute thing I didn't think to check...
Meh..

Thanks man

Im pretty sure that you don't need a semi-colon on the end of SQL queries (i'll try and find where that was written), however the problem may be related to putting the date in. This depends what format it is... though I assume its probably not an integer, in which case you should have quotes around it.

Try this:

PHP Code:

$query="INSERT INTO user_main (email_address,username,password,signup_date,email2,email) VALUES('$email_address','$username','$db_password','$signup_date','$email2','$email')"; 


(There is not supposed to be spaces between 'email' and '2', but I can't get rid of them)

Here: according to php.net (http://uk.php.net/manual/en/function.mysql-query.php):

Note: The query string should not end with a semicolon.