php 循环查询mysql,PHP MySQL计数器/循环查询

我正在进行MySQL查询以搜索数据库中的项目。我已经从搜索表单中提取变量，但是我的WHERE子句遇到了一些问题。因为我不想搜索未在表单中输入的字段。我现在的代码是：

$query = " SELECT RequestID, clients.ClientName, clients.Username, RequestAssignee, requests.StatusID, requests.PriorityID, StatusName, PriorityName

FROM requests

INNER JOIN clients ON requests.ClientID = clients.ClientID

INNER JOIN statuses ON requests.StatusID = statuses.StatusID

INNER JOIN priorities ON requests.PriorityID = priorities.PriorityID

WHERE ";

if(!empty($RequestID))

{

$query2 .= "RequestID = '" . $RequestID . "' OR ";

}

if(!empty($ClientName))

{

$query2 .= "clients.ClientName = '" . $ClientName ."' OR ";

}

if(!empty($Username))

{

$query2 .= "clients.Username = '" . $Username . "' OR ";

}

if(!empty($RequestAssignee))

{

$query2 .= "RequestAssignee = '" . $RequestAssignee . "' OR ";

}

if(!empty($Status))

{

$query2 .= "statuses.StatusName = '" . $Status ."' OR ";

}

if(!empty($Priority))

{

$query2 .= "priorities.PriorityName = '" . $Priority ."'";

}

但是，您可以看到一个问题，即如果某人只搜索一个字段，则查询会在末尾添加“OR”，从而导致错误：

SELECT RequestID, clients.ClientName, clients.Username, RequestAssignee, requests.StatusID, requests.PriorityID, StatusName, PriorityName FROM requests INNER JOIN clients ON requests.ClientID = clients.ClientID INNER JOIN statuses ON requests.StatusID = statuses.StatusID INNER JOIN priorities ON requests.PriorityID = priorities.PriorityID WHERE RequestID = '3' OR

我猜我将不得不放置某种循环或计数器但不确定如何接近它。有任何想法吗？

谢谢，马特。