Announcement

Collapse
No announcement yet.

Adding a Custom Profile Field and Setting Existing User's Preference

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Adding a Custom Profile Field and Setting Existing User's Preference

    So I created a new Profile Field that users can either select Yes or No on. The problem is however that I have about 30 members or so and they don’t have one or the other selected since they registered prior to the change.

    I was looking to run a MYSQL query that would choose that field from the database and automatically select “No” for the existing users. Any idea how I would go about doing this?

  • #2
    Try this...
    Code:
    UPDATE
        userfield
    SET
        field6 = 'No'
    WHERE
        field6 = ''
    Change field6 as required.
    Lats...

    Comment


    • #3
      Originally posted by Lats View Post
      Try this...
      Code:
      UPDATE
          userfield
      SET
          field6 = 'No'
      WHERE
          field6 = ''
      Change field6 as required.
      Worked perfect, thanks so much!

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X