Support Tickets - CMS - Plugin Blog - frontend

CMS - Plugin Blog - frontend

CMS 07.06.2017 2050 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.2

Release date: 07.02.2024

PHP 8.3 ready, ChatGPT improvements and much more...

Cloud Chat 3 / Version 3.1.5

Release date: 13.02.2024

PHP 8.3 ready, ChatGPT, improved language files and bug fixes.

HelpDesk 3 / Version 4.2.1

Release date: 02.04.2024

Improved ChatGPT, File upload better security, front end editor.

Cloud Desk 3 / Version 2.1.5

Release date: 20.02.2024

PHP 8.3 ready, ChatGPT improvements, bug fixes.

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