Hello,
I am having a problem with french characters, it's not how to display them but rather searching for them.
Let`s say 2 items in my DB is called éléphant, and elephant
And if a user searches for anything with "é" i would like only the éléphant to show. The way it's now, both will
This is how my code is set up now.
quicksearch_List = (get_magic_quotes_gpc()) ? $_GET['quicksearch'] : addslashes($_GET['quicksearch']); (I learned that it`s a good idea to put that because of some SQL injections -- instead of simply putting $_GET['quicksearch'])
$query_List = sprintf("SELECT package, name, streetnumber, address, addressinfo, description, type, events, food, music, location, days, icons FROM listing WHERE name LIKE '%%%s%%'", $quicksearch_List);
I would also like to keep the addslashes above.
Thank you