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.

[cinq]

I dun have access to see how the userfield table looks like now, but I believe you can obtain the userid of the person who is only just registering by using :

PHP Code:

$newuser = $DB_site->insert_id(); 


[Lionel]

I am looking for the where statement

PHP Code:

UPDATE userfield SET field10 = SUBSTRING(MD5(userid) FROM 10 FOR 5) WHERE insert_id()"); 


So it would be like that?

[Marco van Herwaarden]

[sql]WHERE userid = $userid[/sql]try that one, but best would be to add the field10 to $userfieldnames and $userfields before the original query, so it would already get updated there. No need for an extra query then.

PS You should never experiment with coding on a live board.

[Lionel]

Thanks Marco. I got burnt a couple times with experiments. Thank God for backups.

That did not insert anything.

Duh, that's exactly what I meant. I was sleeping. That was field15 instead of field10. Field10 is for the weather. I got it set default to Miami. I registered and the weather displayed for Chad Nigeria. hahaha

[cinq]

Sorry just reread your query.
I think you should be doing this, like Marco mentioned.

PHP Code:

UPDATE userfield SET field10 = SUBSTRING(MD5(userid) FROM 10 FOR 5) WHERE userid = $userid