in reply to Re: Re: muli-records db update using cgi
in thread multi-record db update using cgi

I suggest you to use HTML::Template and build your editable table like this (untested):
<form> <TMPL_LOOP NAME=entries> <table id="CD" class="default"> <tr class="grey"> <td class="small">ID:</td> <td><TMPL_VAR NAME=id></td> <td class="small">Title:</td> <td> <input type="Text" name="title" value="<TMPL_VAR NAME=title>" /> </td> <td class="small">Comment:</td> <td> <input type="Text" name="comment" value="<TMPL_VAR NAME=comment> +" /> </td> </tr> </table> <br /> </TMPL_LOOP> <input type="Submit" name="Update" value="Update"> <input type="reset"> </form>
If your script is called with an action 'find', you query your database and fill the table. If the action is 'update' you use the params and update-query the db.
neniro