Weird Parse error...

[Kudose]

Error

You have an error in your SQL syntax near '(username='Kudose', password='XXXXXX', fname='Travis', lname='XXXXXX', age='' at line 1

Script

mysql_connect('localhost', 'XXXXXX', 'XXXXXX') or die('Could not connect to MySQL because:'.mysql_error());

mysql_select_db('DB_XXXXXX) or die("Error connecting to DB because:".mysql_error());

mysql_query("INSERT INTO users SET (username='$username', password='$password', fname='$fname', lname='$lname', age='$age', email='$email', city='$city', state='$state'") or die(mysql_error());

Any help would be much appreciated.

[Kudose]

I have also tried instead of SET using VALUES, but get the same result if that will help anyone who is viewing but not helping :p

[eoghain]

You are writting your SQL incorrectly:

INSERT INTO users (username, password, fname, lname, age, email, city, state)
VALUES ('$username', '$password', '$fname', '$lname', '$age', '$email', '$city', '$state');

That is the correct syntax for an INSERT statement.

You don't have to include the list of fields after the table name if you put your values in the order that the fields were created, and you aren't leaving any fields blank.

[Kudose]

mysql_connect('localhost', 'XXXXXX', 'XXXXXX') or die('Could not connect to MySQL because:'.mysql_error());
mysql_select_db('DB_XXXXXX') or die("Error connecting to DB because:".mysql_error());
mysql_query("INSERT INTO users (username, password, fname, lname, age, email, city, state)
VALUES ('$username', '$password', '$fname', '$lname', '$age', '$email', '$city', '$state'");

For some reason it won't post to the DB.

[cgraz]

You're missing a closing parenthesis around the VALUES part of your query. Should be

mysql_query("INSERT INTO users (username, password, fname, lname, age, email, city, state) 
VALUES ('$username', '$password', '$fname', '$lname', '$age', '$email', '$city', '$state')"); 

Cgraz