icrf wrote: "In SQL I've worked with, there's no literal "TABLE" in an insert statement, just the specific table reference."
well course. Let me clarify so that you know that I actually know SQL:
my SQL statement is:
$mysql = "INSERT INTO TABLE database.table (field1,field2) values...