public static function getByCategorySearch($category) { global $db; $sql = "SELECT * FROM items WHERE categoryid IN (SELECT categoryid FROM categories WHERE number LIKE ?)"; $values = array($category); $items = $db->qwv($sql, $values); return Item::wrap($items); }