Show records from multi select menu

Hi ryan_dot,

What's the name of the field in the 'developments' table that has the agents values in it? Can you print out the value of that field and post it. Try some code like this, except with the correct fieldname:

<xmp><?php print_r($developmentsRecords['agents']); ?></xmp>

The first step is determining what values we have. Then figuring out how to turn it into a where query.

Hi Dave, found a post on the forum where you answered this before, spent hours looking yesterday with no joy and it was near the first post i found today.

Thanks,

http://www.interactivetools.com/forum/forum.cgi?post=63527

This is the code i used

// get where
$recordNumbersArray = getListValues('developments', 'agents', $developmentsRecord['agents']);
$recordNumbersAsCSV = join(', ', $recordNumbersArray);
if (!$recordNumbersAsCSV) { $recordNumbersAsCSV = "0"; }

// prevent error from having empty string if no matches
// load all records
list($estate_agentsRecords, $estate_agentsMetaData) = getRecords(array(
'tableName' => 'estate_agents',
'allowSearch' => '0',
'where' => "num IN ($recordNumbersAsCSV)",

));

Hi Ryan,

Glad you got it sorted out! Let me know if you need anything else. :)