Showing articles only for members with a specific member level

Hi Jerry, 

What's an estimate of the number of articles and authors you expect?

One way to do it is to do a query to get all the usernums who have a "master" level membership, then another query to load all articles that have been created by a user in that list of user nums.

Let me know, thanks!

Hi Jerry, 

Maybe you could do a sub-query as a where.

So say you want to get a list of all the user numbers that have "a" in their username, here's a query for that:

SELECT num FROM cms_accounts WHERE username LIKE "%a%"

And then you want a list of all the articles:

SELECT * FROM cms_articles

Or a list of all the articles from created by users who have an "a" in their username:

SELECT * FROM cms_articles WHERE createdByUserNum IN (SELECT num FROM cms_accounts WHERE username LIKE "%a%")

Or as a getRecords option:

'where' => " createdByUserNum IN (SELECT num FROM cms_accounts WHERE username LIKE '%a%')", 

Would something like that work for you? 

Hi Dave,

That's just what I needed.

I used the last suggestion in the load records call, like this: (adding the requirement of the "status" field having the value "available")

 <?php // load records from 'lm_listing'
  list($lm_listingRecords, $lm_listingMetaData) = getRecords(array(
    'tableName'   => 'lm_listing',
    'loadUploads' => true,
     'where' => " createdByUserNum IN (SELECT num FROM cms_accounts WHERE internal_notes LIKE '%12.%') AND status = 'Available' ", ",
    'perPage' => $maximages,
  ));
 ?>

And it seems to work perfectly.

Thanks again,

Jerry Kornbluth