LIKE My SQL

[bleak26]

Hi guys and Girls of webmaster world thankyou for all your help, now we have another one for you.

We have used this statment to preform LIKE searchs in our data. When we search for "caroline" in customers.firstname the caroline record is retrived but when we search for "caroli" nothing is returned. Is there a better way to do LIKE searches or is there another method we should be using.

$sqlstatement = "select * FROM customers WHERE(customers.firstname LIKE '".$searchterm=$_POST['search']."')";

[ChadSEO]

bleak26,

You need to add wildcards (%) into your Like statement, ala:

$sqlstatement = "select * FROM customers WHERE(customers.firstname LIKE '%".$searchterm=$_POST['search']."%')";

Chad