> is there a way I can INSERT the new record and get mysql to tell > me the row_id value without querying a second time? hi paul yes http://www.mysql.com/doc/en/mysql_insert_id.html rudy