Profile fields

[ProFifaLeagues]

When adding new profile fields and in this instance having 3 different options to choose from,Ive set a default option to be checked but how can i update so that all users have this option updated as its only adding the default option as checked on the new sign ups we have rather then members in the database already!

[Lynne]

You'll have to go into the database and do a query to do this.

[ProFifaLeagues]

Thanks Lynne any ideas what the query i would need to run would be?

[Lynne]

Something to do with the userfield table. Something *like*

UPDATE userfield
SET fieldx=yyy
WHERE fieldx=''I would backup the database first whenever doing something to the database. I would also do this on your test site first to make sure you have the query correct.

I have NOT run this query and have no idea if it is correct! Use at your own risk.

[ProFifaLeagues]

Ok thanks for the advise Lynne i will make sure to do so!