function findSales($connection, $artistID) { $query = "select `itemArray`,`priceArray` from `receipts` where `itemArray` LIKE '%AN" . forceStringLength($artistID, 3, 0, true) . "%' OR `itemArray` LIKE '%PN" . forceStringLength($artistID, 3, 0, true) . "%';"; $database = queryDatabase($connection, $query); return $database; }
function compareItemCodeWithID($item, $id) { $temp_artist_id = forceStringLength($id, 3, 0, true); return strpos($item, (isGS($item) ? "PN" : "AN") . $temp_artist_id) === 0 ? true : false; }