Announcement

Collapse
No announcement yet.

Braindead individual with a query question

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

  • Braindead individual with a query question

    I still have issues with joins.

    What I need to do: I need to run a query that updates a custom profile field to a given value if the user is a member of a certain usergroup.

    Amy
    http://www.eaforums.com

  • #2
    You can't run an UPDATE with a JOIN so what I would do is I would first select all users from that usergroup and put all the userids into a comma separated list and do this:

    UPDATE userfield SET fieldx = "something" WHERE userid IN (comma separated list)

    Comment

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