I need to do my own version of phpMyAdmin for my php class. I encountered problem when trying modify existing data on database. I don't know what would be best way to modify whole table's data when I don't know exact amount of rows or columns. At this point I list existing table to <input type=text> and have also hidden inputs for delivering data to my updater php file. But what would be best way to actually update data to database. Do I just loop through all data and update it one by one or in a one big sql query or what? I don't want you guys to do this for me so no need for ready code, only the general idea.
Thanks in an advance.
Edit. Just realized I don't need that hidden input really for anything so that's gone but main problem still exists.