[mv] late in the day help - looping from vars

[Adam Kett <adam@opusvl.com>]

******    message to minivend-users from Adam Kett <adam@opusvl.com>     ******


I have a problem........ but apart from that I was wondering If anyone can help me with
the following syntax possibles

i need to be able to loop a section of code with in a MV page

such as

for (1..[value total_counter])
  [scratch sql-selects-writes-rm]


what I am trying to do is

    1) select a specific line of info from a mysql table grouped by a code
    2) set all the needed info from it in to vars
    3) Write those vars into a different table
    4) rm item from soucre table
    5) blank vars
    6) repeat for next item till there are none

problems

each amount of items are not a fixed amount so there is no static shortcuts :(

can not do a joined select/insert through mysql :(

 can not place sql within sql :(

 not that well versed in perl :(   (not yet anyway and need this soon, hence can not do back end
script at mo)

 mv is serial in nature (html generating)




any help that anyone can offer will be greatly apreicated.



--
'Darn it, who spiked my coffee with water?!' - larry wall

-
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