Hi all -
I am having a problem getting records from one table to show up with records from another.
Here's the idea...
I have a section called "models". This section was built to show the different models of building available.
Each model can have a multitude of floor plans. I have created another section called "floor plans" and tie the floor plans to the models with a drop down option (get options from a database).
So, if I have a model called Sandy Lake, I can now make as many floor plans as I want for Sandy Lake.
Now, the part I am failing at the moment:
How do I get all of the floor plans for Sandy Lake to show up on the model page for Sandy Lake?
list($modelsRecords, $modelsMetaData) = getRecords(array(
'tableName' => 'models',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$modelsRecord = @$modelsRecords[0]; // get first record
list($floor_plansRecords, $floor_plansMetaData) = getRecords(array(
'tableName' => 'floor_plans',
));
Thanks in advance...
Kenny