Andromeda100 Posted November 14, 2012 Posted November 14, 2012 Hi, I installed the contrib "Autocomplete JQuery. I like the contrib, but it does't work for products with special characters like Ö, Ü, Ä and so on. I tried to customize but I havn't found any solution. Could anyone help me, please? This is my autocomplete.php <?php require('includes/application_top.php'); $return_arr = array(); $fetch = tep_db_query("select * from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id WHERE p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and pd.products_name LIKE '%" . $_GET['term'] . "%'"); while ($row = mysql_fetch_assoc($fetch)) { $test=$row['products_name']; array_push($return_arr, $test); } print json_encode($return_arr); ?>
Recommended Posts
Archived
This topic is now archived and is closed to further replies.