mysql_query does not work

Can someone help me figure out why this code isn't working.

I am connected to the DB. This snippet is within php tags.

$result=mysql_query("INSERT INTO attendee开发者_StackOverflow中文版ser (firstName, lastName, shirtSize, title, organization, emailAddress, q1, q2, q3, refId)
             VALUES ('$_POST[firstName]', '$_POST[lastName]', '$_POST[shirtSize]', '$_POST[title]', '$_POST[organization]', '$_POST[emailAddress]', '$_POST[q1]', '$_POST[q2]', '$_POST[q3]', 'NULL')");

---

I figured it out. I didn't have q3 as a field in the table.

---

Yeah, someone probably entered a quote or something. DO NOT INSERT THIS WAY, you are wide open to SQL injection attacks.

Use PDO, or mysql_real_escape_string() at a minimum.

---

execute this

if(!mysql_query("INSERT INTO attendeeser (firstName, lastName, shirtSize, title, organization, emailAddress, q1, q2, q3, refId)
             VALUES ('$_POST[firstName]', '$_POST[lastName]', '$_POST[shirtSize]', '$_POST[title]', '$_POST[organization]', '$_POST[emailAddress]', '$_POST[q1]', '$_POST[q2]', '$_POST[q3]', 'NULL')")){
echo mysql_error();
}

that will display the error generated by mysql.