where like php,Php select * where like

嗨,我正在尝试搜索网站的搜索.它有2个输入信息,一个是下拉列表.

Search for an Item

Keywords

Select A Location

Any Location

Antrim

Armagh

Carlow

Cavan

我似乎无法弄清楚如何组合2个输入来给出结果,我可以单独做,但不能一起工作以获得更准确的结果.

PHP

$keywords = $_POST['keywords'];

$keylocation =$_POST['location'];

$username = $_SESSION['username'];

//MySQL Database Connect

include 'connect.php';

//make sql query

$result = mysqli_query($con,"SELECT * FROM projectitem where description like '%$keywords%' or item like '%$keywords%' or location like '%$keywords%'");

提前致谢！