PHPMyAdmin challenge

[MoothMan]

I hope someone will come up with an answer to this...I am sure it is very easy for someone with the knowledge.

I have a custom profile field which did not used to be required on registration, but is now. I have searched through phpmyadmin and have 1000 people who have this field blank. I have the user IDs but would like to associate these with usernames...Anyone know how I can do this?

Many thanks in advance :)

[Code Monkey]

What is it you are trying to do? What is it you want to accomplish?

[Adrian Schneider]

Something like this?
SELECT userfield.fieldX, user.username
FROM tablePrefix_userfield as userfield
LEFT JOIN tablePrefix_user as user using (userid)
WHERE userfield.fieldX = ''

[Code Monkey]

And there is also a hack, I believe, that will require users to enter the info next time they log in. Depends on what it is you are trying to accomplish.

[MoothMan]

@jumpD, that is exactly what I want to acomplish, complience. Any idea who did the hack or what it is called?

@SirAdrian thanks for that, do i change "x" for 6 "field6" as this is the name...or do i need to fill in the WHERE userfield.fieldX = '', this would be a problem as as I am looking for peeps with nothing in that field...

Thanks all

Thx guys, the hack worked for me :)