$sth = $dbh->prepare(
    "SELECT * FROM `items`
    WHERE
      category = '$id' 
    AND
      description LIKE '%$search%'
    OR
      itemid LIKE '%$search%'
    OR
      longdescription LIKE '%$search%' LIMIT $offset, $limit");
 	$sth->execute or die $dbh->errstr;