I have a script that ... and get one of the fields from mysql for the row that I have just entered (the ID field, which mysql increments)

from perldoc DBD::mysql

     $insertId = $dbh->{'mysql_insertid'}

     ...

     mysql_insertid
         MySQL has the ability to choose unique key values
         automatically. If this happened, the new ID will be
         stored in this attribute. This attribute is not valid
         for DBD::mSQL. An alternative way for accessing this
         attribute is via $dbh->{'mysql_insertid'}. (Note we are
         using the $dbh in this case!)
[download]

just a reminder, $dbh is the database handle, not the statement handle

also, look here

Will perl for money
JJ Knitis
(901) 756-7693
gt8073a@industrialmusic.com