[ic] MySql insert with form

[interchange-users@interchange.redhat.com (Alma Nuker)]

Hi;

I am trying to insert some form data to mysql DB.

I have folowing in my form:

[set mv_data_enable]1[/set]
[tag flag write]websitedb[/tag]
[seti webiste_id][counter][/seti]
<FORM METHOD="POST" ACTION="[process]">
<INPUT TYPE=HIDDEN NAME="mv_data_table" VALUE="websitedb">
<INPUT TYPE=HIDDEN NAME="mv_data_key" VALUE="website_id">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="insert"><INPUT
TYPE=hidden NAME="mv_form_profile" VALUE="website_profile">
<INPUT TYPE=HIDDEN NAME="mv_data_fields" VALUE="website_id"...etc>

<INPUT TYPE=HIDDEN NAME="website_id" value="[scratch website_id]">

in my websitedb.mysql I have following:

Database  websitedb  websitedb.txt   __SQLDSN__
ifdef SQLUSER
Database  websitedb  USER         __SQLUSER__
endif
ifdef SQLPASS
Database  websitedb  PASS         __SQLPASS__
endif

Database  websitedb  COLUMN_DEF   "website_id=INT(3) NOT NULL PRIMARY
KEY"

etc..............

and also in my websitedb.txt file:

website_id      name    company etc (with TAB in between).

When I fill out info in my form and press send button I have following
error message in my  error.log:

No key 'website_id' found for function='insert' table='websitedb'

Can someone help please.

Alma