webERP web-based ERP Accounting

TaxProvinces.php
Version - 3.11
Line 120
$sql= "SELECT COUNT(*) FROM locations WHERE taxprovinceid " . LIKE . " '" .
$OldTaxProvinceName . "'";

Before a tax province is deleted a check occurs to insure the province is
not in use before deleting. The check fails and as a result tax provinces
can be deleted even though locations still exist that use the province
record. I could be wrong but it appears the reason the fail occurs is
because the PHP sql string is malformed at the LIKE and perhaps should
be...
$sql= "SELECT COUNT(*) FROM locations WHERE taxprovinceid LIKE '" .
$OldTaxProvinceName . "'";

Bryan