[mv] inserting data into a SQL database

[Scott Benson <scott@rant.tzo.com>]

******    message to minivend-users from Scott Benson <scott@rant.tzo.com>     ******

I have created some extra tables in the database (MySQL) for a simple
customized order status query and an affiliates program.

Currently I have it putting the data in for the affiliate at the end of
the receipt.html with this bit of code:

[sql type=set base=affiliateorders interpolate=1]
 insert into affiliateorders
 values
 ('[value mv_order_number]',
 '[subtotal]',
 '[data session source]'
 )
[/sql]

which seems to work ok. Yeah I know - I need to check and make sure that
data session source is assigned, but will do that later..

My question is - would it be better to have etc/report do the work,
where it inserts the transactions info into the database?

Scott Benson

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list