Hi Seasons greetings everyone.
What I am trying to do is select records using 2 alternatives to select records for displaying
' area1 ' is a checkbox available on all records and if checked the value is 1
Using the statement below it is calling up all records in the database - and not just for the 2 alternatives
Using the ' where ' statement on its own works just fine
and only calls up leeds records
can somebody tell me what I am doing wrong?
<?php
require_once "/home/esc110/public_html/cmsAdmin/lib/viewer_functions.php";
list($biosRecords, $biosDetails) = getRecords(array(
'tableName' => 'bios',
'perPage' => '10',
'where' => ' areas_covered LIKE "%leeds%"' or 'area1 "%1%"',
'orderBy' => 'view_order',
));
?>
Thanks - Mel