[ic] mv_data_function insert not working

Mike Holmes mikeofholmes@hotmail.com
Fri, 09 Mar 2001 09:17:19 -0800


Hello List,

I'm trying to insert a new line into the products table, which is in a mysql
database.  I am able to update but haven't had any luck inserting.
This is the relevant code:

<FORM METHOD=POST ACTION="[process]">
<INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="products">
<INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="sku">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="insert">
<INPUT TYPE=HIDDEN NAME="mv_nextpage"      VALUE="admin/add">
<INPUT TYPE=HIDDEN NAME="mv_data_fields" 
VALUE="sku,category,name,description,dimensions,material,mounting,color,price,wholesale,weight">

<INPUT TYPE=TEXT NAME="sku" SIZE=40 VALUE="[value sku]">
etc..

<INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
<INPUT TYPE=submit VALUE="Update table">
<!-- [export products] -->
</FORM>

Any tips?

Thanks
Mike Holmes
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com