Only geting exact match from database query
Posted: Thu Jan 17, 2008 9:49 am
Hi,
when I run the following query I only get the exact match of what I have searched for,
I think I need to use % sign so that I can search for Nic and get also Nicola as a result.
But I can figuer out where to add the %
I use an external webform for the search.
when I run the following query I only get the exact match of what I have searched for,
I think I need to use % sign so that I can search for Nic and get also Nicola as a result.
But I can figuer out where to add the %
I use an external webform for the search.
Code: Select all
$result = mysql_query("SELECT * FROM contacts where first_name LIKE '" . $_POST['search'] ."' OR last_name LIKE '" . $_POST['search'] ."' OR company_name LIKE '" . $_POST['search'] ."' OR website LIKE '" . $_POST['search'] ."' OR street LIKE '" . $_POST['search'] ."' OR city LIKE '" . $_POST['search'] ."' OR zip LIKE '" . $_POST['search'] ."' OR country LIKE '" . $_POST['search'] ."' OR mail1 LIKE '" . $_POST['search'] ."' OR mail2 LIKE '" . $_POST['search'] ."' OR phone LIKE '" . $_POST['search'] ."' OR mobile LIKE '" . $_POST['search'] ."' OR card LIKE '" . $_POST['search'] ."' OR birthday LIKE '" . $_POST['search'] ."'") or die (mysql_errno().": ".mysql_error()."<BR>");