I added the string replace function but still a No-Go..
//strips currency markup
function WADS_stripCurrency($currencyField) {
if (isset($currencyField) && $currencyField != "undefined" && $currencyField != "") {
if (is_numeric($currencyField)) {
return $currencyField;
}
else {
return preg_replace("/[^\d\.]/", "", $currencyField);
return str_replace(",", "", $currencyField);
}
}
return "";
}
echoing back the $currencyField value on the search page is not showing this present so maybe that was the wrong variable to be looking to manipulate?
Here is the search query string and results of echoing $currencyField:
SELECT tblhouseinfo.BedRooms, tblhouseinfo.BathRooms, tblhouseinfo.list_price, tblinventory.* FROM tblhouseinfo JOIN tblinventory ON tblinventory.invId = tblhouseinfo.addInfoID WHERE tblinventory.mid = 10 AND (list_price >= 24000) AND (list_price <= 45000) First Previous Next Last
Notice: Undefined variable: currencyField in E:\Websites\......\www\htdocs\results.php on line 209