Announcement

Collapse
No announcement yet.

extract info from database profile fields

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

  • extract info from database profile fields

    I run a motorbike forum which organises rides, on a recent event we had an incident where we discovered we knew very little about one of the members attending other than his forum user name. I decided to add additional user profile fields for contact name, telephone number and users phone number. these are all private fields not viewable.

    What I now need to do is be able to produce a list of those members who have completed the fields for future ride outs but I don't know how. the fields are number 11,12 and 13. I'm useless with SQL or command line stuff, can anyone give me an idea of how to do this please.

    TIA

    michael

  • #2
    SELECT username, email, field11, field12, field13 FROM user LEFT JOIN userfield USING (userid) WHERE field11 != '' AND field12 != '' AND field13 != '';

    Try that SQL query.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment

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