$q1 = "WHERE title LIKE '%$query%' AND active = 1 AND status = 3";
$q2 = "WHERE cat_id = $pcat AND active = 1 AND status = 3";
$q_cat = ($pcat != 0) ? $q2 : "";
$fltr = (!empty($q_cat)) ? $q_cat : $q1;
$prj = mq("SELECT * FROM prj $fltr ORDER BY id DESC");
if (mnr($prj) > 0) {
while ($prjq = mfa($prj)) {
$c_img = img($prjq['img_main']);
$c_title = $prjq['title'];
$c_desc = $prjq['description'];
$c_goal = $prjq['goal'];
$c_raised = $prjq['raised'];
$c_enddt = $prjq['enddt'];
$c_memberid = $prjq['member_id'];
$slug = slug($c_title);
$href = $site_url . "maklumat-donasi/" . $prjq['id'] . "/" . $slug;
$mmbr = mq("SELECT * FROM member WHERE id = $c_memberid");
$mmbrq = mfa($mmbr);
$c_orgname = $mmbrq['oname'];
$c_dleft = dtdiff(now(), $c_enddt);
?>
include "components/donation-card.php" ?>
}
} else { ?>
= $lg['no-fund-found'] ?>
} ?>