Apart from use-ing strict and warnings - which you certainly do, I'm sure - you should look at CGI and DBI.

As for populating the fields in the same form, it seems to me that you'll have to put the script into the file with the form and then have it call itself.

--cs

There are nights when the wolves are silent and only the moon howls. - George Carlin