Right now for my php web app with pgsql, I have a section where the user has a list of software and an input box next to each title where you input how many copies are going to be used.
The whole form mainly deals with 2 tables:
softroom[rid, sid, added, total]
software[id, title, version, site, ltype, lnum, platform]
So the user picks a room which has an id, and then inputs amount for titles, example
room 250
flash 20
ms word 20
ms excel 20
and then it inputs in the db
softroom[ 4, 1, 20060101, 20]
softroom[ 4, 2, 20060101, 20]
softroom[ 4, 3, 20060101, 20]
softroom[ 4, 4, 20060101, 20]
now the problem is that each form, I usually enter liek 50 titles, and it takes time, and the thing is that the next room i have to input software stuff has the same software but different amounts for example for room 350:
room 350
flash 30
ms word 30
ms excel 30
and then it inputs in the db
softroom[ 5, 1, 20060101, 30]
softroom[ 5, 2, 20060101, 30]
softroom[ 5, 3, 20060101, 30]
softroom[ 5, 4, 20060101, 30]
Is there a quick way of copying records in a db but just change the amount and room id or something?
