I want to hide the drop down and query 3 options for the form report. I need some help with the sql query.
Code: Select all
if ((!empty($_GET['deviceuseage']))&&($_GET['deviceuseage'] != 'all'))
{
$sql .= " and deviceuseage like '". addslashes($_GET['deviceuseage'])."%' ";
}I tried without any success.
Code: Select all
if ((!empty($_GET['deviceuseage']))&&($_GET['deviceuseage'] != 'deviceuseage = 'server' OR deviceuseage = 'printer' OR deviceuseage = 'workstation'))
{
$sql .= " and deviceuseage like '". addslashes($_GET['deviceuseage'])."%' ";
}