Support Tickets - CMS - Plugin Blog - frontend

CMS - Plugin Blog - frontend

CMS 07.06.2017 99 Feedback Status: Open Solution: No bluesatkv


Bad count

$resultgt = $jakdb->query('SELECT COUNT(*) as totalAll FROM ' . $jaktable . ' WHERE ((startdate = 0 OR startdate <= ' . time() . ') AND (enddate = 0 || enddate >= ' . time() . ')) AND catid IN(' . smartsql($page2) . ') AND active = 1');
$getTotal = $resultgt->fetch_assoc();

This value isn't good because article can more ona category :-)

smartsql($page2)
Sign in to see the solution.