Welcome Guest, Not a member yet? Register   Sign In
Search with an apostrophe in mySQL
#2

[eluser]nirbhab[/eluser]
SELECT * FROM addDVD WHERE title LIKE '%ocean\’s 11%' ORDER BY title ASC

Code:
$search_it = "ocean’s";
$key = addslashes($search_it);
$sql = "SELECT * FROM addDVD WHERE title LIKE '%$key%' ORDER BY title ASC";


Messages In This Thread
Search with an apostrophe in mySQL - by El Forum - 03-30-2008, 11:31 PM
Search with an apostrophe in mySQL - by El Forum - 03-30-2008, 11:35 PM
Search with an apostrophe in mySQL - by El Forum - 03-31-2008, 08:09 PM



Theme © iAndrew 2016 - Forum software by © MyBB