Question about filtering multiples in where

2 posts by 2 authors in: Forums > CMS Builder
Last Post: March 28, 2016   (RSS)

By MatrixHyperLoop - March 25, 2016

$options = $pagesRecord['option_sets'];

// load records from 'gear_options'
  list($gear_optionsRecords, $gear_optionsMetaData) = getRecords(array(
    'tableName'   => 'gear_options',
    'where'   =>  "`num` = '$options'",
    'loadUploads' => true,
    'allowSearch' => false,
  ));

$options prints as 1 2 what i'm trying to do is only show records with the nums in the $options variable, how would i go about accomplishing this?

By Damon - March 28, 2016

Hi,

Is the option_sets a multi-value check box or select?

To confirm are you trying to return records with num 1 and 2?

Can you provide more details as I'm not fully clear what the results you are after?

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/