[SOLVED] db writing issue with mysql

[ballhogjoni]

can someone help me understand why this is not saving to my db? The variables are being passed because I can echo them, but they are not writing to my db.

$fname=$_POST['fname'];
$lname=$_POST['lname'];
$position=$_POST['position'];
$email=$_POST['email'];
$state=$_POST['state'];
$areacode=$_POST['areacode'];
$prefix=$_POST['prefix'];
$linenumber=$_POST['linenumber'];

$query = "INSERT INTO contact_n_questions ('fname','lname','position','email','state','areacode','prefix','linenumber') VALUES ('$fname','$lname','$position','$email','$state','$areacode','$prefix','$linenumber')";
mysql_query($query);

[papaface]

try:

$fname=$_POST['fname'];
$lname=$_POST['lname'];
$position=$_POST['position'];
$email=$_POST['email'];
$state=$_POST['state'];
$areacode=$_POST['areacode'];
$prefix=$_POST['prefix'];
$linenumber=$_POST['linenumber'];

$query = "INSERT INTO contact_n_questions ('fname','lname','position','email','state','areacode','prefix','linenumber') VALUES ('$fname','$lname','$position','$email','$state','$areacode','$prefix','$linenumber')";
mysql_query($query) or die ("error: " . mysql_error());

 

Tell us the error.

 

[ballhogjoni]

error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''fname','lname','position','email','state','areacode','prefix','linenumber') VAL' at line 1

[mpharo]

your syntax looks fine, are you sure you have the correct column names  and data types?

[ballhogjoni]

Ya i have every thing correct. I figured out what it was. The working code looks like this:

$fname=$_POST['fname'];
$lname=$_POST['lname'];
$position=$_POST['position'];
$email=$_POST['email'];
$state=$_POST['state'];
$areacode=$_POST['areacode'];
$prefix=$_POST['prefix'];
$linenumber=$_POST['linenumber'];

$query = "INSERT INTO contact_n_questions (fname, lname, position, email, state, areacode, prefix, linenumber) VALUES ('$fname','$lname','$position','$email','$state','$areacode','$prefix','$linenumber')";
mysql_query($query) or die ("error: " . mysql_error());

 

I just took out the quotes('') and it worked fine.