[Resolved] SQL Query Broken

mberman

I'm having issues with SQL queries at the moment. I can't figure out why this isn't working:

mysql_query ("INSERT INTO game (id, name, opnt, lctn, year, month, day, q1, q2, q3, q4, ot, q1them, q2them, q3them, q4them, otthem) VALUES ('', '$name', $opnt', '$lctn', '$year', '$month', '$day', '$q1', '$q2', '$q3', '$q4', '$ot', '$q1them', '$q2them', '$q3them', '$q4them', '$otthem')");

I figure I'm missing something somewhere, but all SQL says is:

Error creating table!You have an error in your SQL syntax near '', 'test', '2007', '2', '6', '1', '2', '3', '4', '55', '1t', '2t', '3t', '4t', '' at line 1

(all the numbers represent values I filled in for the form. 1-> q1, etc. )

I'm stumped.

bobbyb98

Don't think I'm a moron, but to get "Error creating table" would make me think that your table isn't setup properly, or that your table name has an s on the end that you forgot to put in your code... Maybe something more simple than you thought... Also, remember to check the simple things, like query that same table on that same database and make sure that your information is showing up properly. Check your connections, make sure you aren't connected to the wrong datbase, etc...

If it were your values throwing it, you would usually get an error like "More Fields Listed, than values" etc...

xblue

why do you want to set an empty value as id?

if it is auto-incrementing, you don't need it in your query at all, i.e.

INSERT INTO game (name, opnt, lctn, year, month, day, q1, q2, q3, q4, ot, q1them, q2them, q3them, q4them, otthem) VALUES ('$name', $opnt', ...

mberman

Alright. Thanks for your help! Worked out the problem.