one simple line

[Lionel]

in register php,right after:

PHP Code:

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "userfield $userfieldsnames VALUES ($userid$userfields)"); 


I'd like to add

PHP Code:

$DB_site->query("UPDATE userfield SET field10 = SUBSTRING(MD5(userid) FROM 10 FOR 5)"); 


but just for the user who is registering. That code does it for every body.

can someone please just tell me that WHERE statement for the new userid?

PHP Code:

 $DB_site->query("UPDATE userfield SET field10 = SUBSTRING(MD5(userid) FROM 10 FOR 5) WHERE ????"); 


Simple, but I haven't slept for two days, can't figure it out and I don't want a trial and error on a live board where I get people registering constantly.

Thank you.