Re: [mel] How do I display records from just 1 specific region
Hi Mel,
To show only record from a specific region you can use a MySQL Where query like this:
region = "north west"You can either enter that in the code generator (at the bottom under "Filter Results") or in the viewer code like this:
list($records, $recordMetaData) = getRecords(array(
'tableName' => 'bios',
'perPage' => 5,
'where' => 'region = "north west"',
));
And to only display 3 fields just remove all the <?php echo ... ?> tags for the fields you don't want displayed and copy the <a href=""> tag around your image as well.
Hope that helps. Let me know if you need more details or help with that.
Dave Edis - Senior Developer
interactivetools.com