Kendine göre düzenle(bendeki arama sayfası gibi birşey değer yoksa eklemez eğer varsa ekler):

$sqlParam=array();
if ($SearchTitle)
{
$SearchText=trim($SearchTitle);
$sqlAdd=" WHERE (mc_account.Title LIKE ? OR mc_account.Gsm LIKE ?)";
array_push($sqlParam,'%'.$SearchTitle.'%','%'.$SearchTitle.'%');
}

if ($sqlAdd && $StockName) {$sqlAdd.=' AND (';} else if ($StockName) {$sqlAdd.=' WHERE (';}
if ($StockName) {
$sqlAdd.=" mc_stock.StockName = ? )";
array_push($sqlParam,$StockName);
}

if ($sqlAdd && $sFinishDate) {$sqlAdd.=' AND (';} else if ($sFinishDate) {$sqlAdd.=' WHERE (';}
if ($sFinishDate) {
$sqlAdd.=" mc_member.FinishDate <= ? )";
array_push($sqlParam,$sFinishDate);
}

$qlist = $con->prepare("SELECT * FROM mc_account INNER JOIN mc_member ON (mc_account.AccountId = mc_member.AccountId) INNER JOIN mc_stock ON (mc_member.ServiceId = mc_stock.StockId) ".$sqlAdd);
$qlist->execute($sqlParam);



foreach( $qlist as $row ){
?>







}
?>