extract info from database profile fields

[Gizmo999]

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

[Colin F]

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

Try that SQL query.