SQL Query

Hi Tim,

In this case you might be better using an IN statement, something like this should work:

SELECT s.num FROM `<?php echo $TABLE_PREFIX . nlb_subscriber_table() ?>` s
 WHERE s.`<?php echo nlb_subscriber_confirmedField() ?>` = 1
   AND `membership_type` IN('5','3')


So the IN function checks if a field contains the comma separated values in the function.

Cheers

Greg

Perfect. Thanks.

Is there any resources where I can read up on this kind of thing?  Or even better, a list of common queries that would be used with CMSB?

Hi Tim,

Unfortunately we don't have a resource for common MySQL functions. I'm not sure it would be possible as so many queries are completely unique, and they become complicated once you've gone outside of the basic where statement.

Cheers

Greg