No announcement yet.

extract info from database profile fields

  • 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.



  • #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.


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