[QUOTE=Jason Byrnes;11995]Most likely, there is a column name that uses a MySQL reserved word that is causing the error.
Double check your column names against this list:
Hi, thanks for the reply, ive checked my column names against that list, its not that. Ive also tried creating a really basic form with 3 fields and made a new database and table for it in myphpadmin, the same thing is happening. in the server behaviors i can connect to the database fine, it sees the table, but doesnt see any of the columns! its so annoying!