Search/filter question

Any thoughts on this?

Hi there.

Thanks for posting.

What you will need to do is create a custom "WHERE" and use that to filter the results. 

The custom "WHERE" will be where you can use the "OR" searches:

"where" => "melt_type = 1 OR melt_type = 2 OR melt_type = 3"

How comfortable are you with custom "WHERE"?

Let me know what you think.

Thanks!

Hi there.

You can build a custom query using values from the query string using $_REQUEST.

It could look something like this:

$customWHERE = "";

$customWHERE =  "melt_type = ". mysql_escape(@$_REQUEST['melt_type']);
$customWHERE .= " OR melt_type = ". mysql_escape(@$_REQUEST['melt_type']);

And then in your getRecords, you would use something like this:

// load records from 'another_multi_section'
list($another_multi_sectionRecords, $another_multi_sectionMetaData) = getRecords(array(
  'tableName' => 'another_multi_section',
  'loadUploads' => true,
  'allowSearch' => false,
  'where'       => $customWHERE ,
));

A couple notes:

1. Make sure you have "allowSearch" set to "False". If that's true, the search you get will be a composite of what's in the query string as well as the custom WHERE.

2. You can create your $customWHERE on a single line if you like. I broke my example into two lines so it's easier to read in a forum post.

Does that all make sense?

Let me know any questions.

Thanks!