Skip to Content Skip to Menu

Querying for specific users based on values fields

  • olaeblue
  • olaeblue
  • OFFLINE
  • Posts: 16
  • Thanks: 0
  • Karma: 0
12 years 6 months ago #197398 by olaeblue
I want to run a query on my users to return all the users who have a field populated, along the lines of:

"SELECT name, cb_ukclimbingid FROM #_comprofiler WHERE cb_ukclimbingid is NOT NULL"

I would then loop through the list returned using the cb_ukclimbingid value to query and return an array of climbs people have undertaken (I can do this bit).

I have had a search of the forums & Kyles tutorials ( www.allmysocials.com/directory/tutorials ) but can't seem to see anything that helps me.

Any advice or pointers where to look?

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum