I have this page that you can do a search on the site. However, if I do a search that contains an apostrophe ('), it breaks and doesn't display anything although I have entries that have them. Does an easy fix exist for this problem?
This is an example of what I have:
$search = $_GET['search']; SELECT * FROM tbl_name WHERE name LIKE '%$search%'