INSERT?

[Anon]

$query = "INSERT INTO matches (opp,game,sscore,escore,played,won,lost,cond) VALUES ('$opp','$game','$sscore','$escore','$played','$won','$lost','$cond')";

For some reason this query doesn't work. Please help me to correct this problem, could it be my Database? It connects and selects with no problems but when trying to insert it doesn't. Thanx

[Anon]

This could be a lot of things. Try putting:

echo mysql_error();

after the mysql_query function call and see if it says anything. Check that all the field names in your query are correctly written. One small typo could be the problem.

[Anon]

Oh my god! I can't thank you enough, I thought I had checked EVERYTHING thousands of times...obviously my checking wasn't good enough because that mysql_error() function told me I had spelt escore as esscore. So easy to miss...anyway, thank you again. 🙂