[SOLVED] Query using "LIKE" statement?

[me1000]

Hello,

 

So here is my problem, I have 2 entries (for now) in the DB the script goes and queries the DB where the searched term is like the TITLE field in the DB,

 

$sql = "SELECT ID,TITLE FROM pages_master WHERE TITLE LIKE '%".$_POST['search']."%' LIMIT 5";

 

Problem is, when it returns the results I get both entries.

 

The TITLEs for the entries in the DB are as follows, "Home" and "Contact Us"

 

So when i search for "hom" I should only get the "Home" entry returned, right?

 

Can someone please explain why I get both entries returned?

 

 

Thanks,

 

 

[revraz]

echo $_POST['search'] to make sure it does in fact contain "hom"

[me1000]

I figured out the problem, the POST data is not "search", it was "query"...

 

Thanks,