Search/filter question

Any thoughts on this?

I am familiar and comfortable with the custom WHERE, but I'm not sure how to utilize it in this situation. How would I inject in custom criteria for the WHERE from the URL? Attached is a screen grab of my page, in case that's helpful.  

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!