In my script, I do the following: I insert x amount of records into a MySQL table, process the information and then delete those records. One of the columns is an autonumber type so it starts at 1 for instance. In my query string I use placeholders. Now sometimes the field which is an autonumber starts out at 1 while other times it starts out at whatever number it left off at. Is that normal? I use the following:
# Load into database $query1 = "insert into data(USER_ID,NAME,etc) values(NULL,?, ?, ?, ? , ?,?,?,?)"; $sth1 = $dbh->prepare($query1); $rc1 = $sth1->execute($Name,$etc); TIA -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]