Support Tickets - CMS - Plugin Blog - frontend

CMS - Plugin Blog - frontend

CMS 07.06.2017 2254 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)

Replies (2)

bluesatkv

Solution

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

Works perfect. If I want to see all article in category :-)

07.06.2017 0

Jerome

Thank you for your input.

07.06.2017 0

CMS http -> https How to login into the forum

Insight our laboratory

Live Chat 3 / Version 5.1.4

Release date: 12.10.2024

Updated ChatGPT, bug fixes and performance improvements.

Cloud Chat 3 / Version 3.1.7

Release date: 14.10.2024

Updated ChatGPT models, bug fixes and performance.

HelpDesk 3 / Version 4.3.1

Release date: 08.09.2024

New ChatGPT Models, language file improvement, bug fixes.

Cloud Desk 3 / Version 2.1.7

Release date: 23.10.2024

New ChatGPT models, bug fixes and performance improvements.

We program modern and fast web and mobile software, always responsive and mobile first! Not just great software also world class support, rated an average of 4.9 out of 5 stars! When you need support from us you will get it!

Feel free to contact us via our contact form at any time, we usually respond in less then 24 hours or start a chat conversation when we are online.

Services

About Us

Some Extra