SQL Insert Problem

[Chris_Evans]

Hi all,
Spent a while looking over this but can't find the problem, it just says: Error in SQL syntax on line 1, near ''

That implies to me a variable hasn't been incorporated properly, anyway, wondered if any of you might be able to "spot the mistake" as I'm at a loss.

		$result = mysql_query("INSERT INTO tests (courseid,chapter,question,answera,answerb,answerc,answerd,answere,answerf,reason) VALUES('$courseid','$chapter','$question','$answera','$answerb','$answerc','$answerd','$answere','$answerf','$reason'")
			or die(mysql_error());

Thanks in advance,

Chris

[tuf-web_co_uk]

$result = mysql_query("INSERT INTO tests  

(courseid,chapter,question,answera,answerb,answerc,answerd,answere,answerf,reason)  VALUES('$courseid','$chapter','$question','$answera','$answerb','$answerc','$answerd','$answere',
'$answerf','$reason')") 
            or die(mysql_error());

[Chris_Evans]

I've just echoed out all my variables and they're all full, none empty, so I'm lost at this point as to why it doesn't work.

The query works in phpmyadmin

Chris

[Chris_Evans]

Originally posted by tuf-web.co.uk

$result = mysql_query("INSERT INTO tests  

(courseid,chapter,question,answera,answerb,answerc,answerd,answere,answerf,reason)  VALUES('$courseid','$chapter','$question','$answera','$answerb','$answerc','$answerd','$answere',
'$answerf','$reason')") 
            or die(mysql_error());

[/B]

Hi there, I take it you meant the bracket! I spent hours trying to find that out because no email came through, anyway, I got the same result and it works. Thanks,

Chris