t get value both Inch Marks & Feet Marks go into database without error
I have a value from our database that has to be inserted into another table when it's selected from a dropdown. I get 'syntax error' upon submitting to enter. It is this: 2.5" Flexible neoprene composite duct, 25' bulk length
When I take off the feet mark from 25', it works fine. I've tried the following:
$myvalue = addslashes($WADAcac_prod_subcategory_leveltwo_NEW_insertx->getColumnVal('prod_name');
$myvalue = str_replace("'", '",$WADAcac_prod_subcategory_leveltwo_NEW_insertx->getColumnVal('prod_name');
$myvalue = str_replace("'", "ft",$WADAcac_prod_subcategory_leveltwo_NEW_insertx->getColumnVal('prod_name');
$myvalue = str_replace("'", "ft",addslashes($WADAcac_prod_subcategory_leveltwo_NEW_insertx->getColumnVal('prod_name'));
$myvalue = addslashes(str_replace("'", "ft",$WADAcac_prod_subcategory_leveltwo_NEW_insertx->getColumnVal('prod_name'));
and many other ways. On top of that, this is from a call to an AJAX function that replaces the code, which works fine, but not sure if that has anything to do with it. The exact code right now is in a do while (all works fine as long as I take off the single quote mark).
Attached is the file that is called using AJAX. Line 102.
Can you help with this? Thanks.
Thanks.