in reply to Re^2: sql queries updation improper
in thread sql queries updation improper

This is where DBI]'s last_insert_id comes in handy ... oh, thats only in DBD::Pg but you can always select the highest id immediately after inserting a record.
just another cpan module author

In Section Seekers of Perl Wisdom