I would like to copy a value 'userID' to a field in the same database 'pid' automatically when someone registers. I use the second as a lookup field. The userID field is an autoincrement. Can this be done?

do go getting in a muddle using PHP when you can simply throw it some sql.

update table set table.pid = table.UserID

can be simply used from your register code.

Ibbo