[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
[mv] Updating Database Via Checkboxes
****** message to minivend-users from "Cameron B. Prince" <info@InternetExpertsLLC.com> ******
Hi list,
I am using a sql query to display a loop of items in a database like this:
[search-region more=1 search="
ra=yes
st=sql
sq=select * from invoices where to_print = 'yes'
ml=999999
tf=invoice_number
"]
In the search list I have checkboxes for each result like this:
<input type="checkbox" NAME="printed" value="[item-data invoices code]">
So what this does is list all the invoices that are to be printed with checkboxes by each one.
What I need to do is create a form of some kind that will update the database and set to_print to 'no' for each checkbox that is checked.
I have had no problems updating Minivend databases when it comes to single items, but I am stumped as to how to do this multiple field update.
Can anyone provide any ideas?
Thanks,
Cameron
-
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