Online PHP editor | refs for t0lRA

<?php /** * TV Module Entry Point August 19, 2018 Ed $ * @package Joomla.site * @subpackage mod_tv * @copyright Copyright (c) 2019 CDXX All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE.txt */ // No direct access defined('_JEXEC') or die; // Include the syndicate functions only once require_once dirname(__FILE__) . '/helper.php'; $db = JFactory::getDbo(); $db->setQuery('SELECT title, introtext FROM #__content WHERE introtext LIKE "%Still Airing%"'); $rows = $db->loadAssocList(); $count = count($rows) / 2; $db = JFactory::getDbo(); $db->setQuery('SELECT title, introtext FROM #__content WHERE introtext LIKE "%Still Airing%" LIMIT ' . $count . ' ORDER BY title ASC'); $rowa = $db->loadAssocList(); $db = JFactory::getDbo(); $db->setQuery('SELECT title, introtext FROM #__content WHERE introtext LIKE "%Still Airing%" LIMIT ' . $count . ' OFFSET ' . $count . ' ORDER BY title ASC'); $rowb = $db->loadAssocList(); ?> <div style="margin:10px;"> <table style="width:100%;"> <tbody> <tr> <td style="font-weight:bold;width:50%;"> <?php foreach ($rowa as $item) { ?> <?php echo $item['title']; ?> <?php } ?> </td> <td style="font-weight:bold;width:50%;"> <?php foreach ($rowb as $item) { ?> <?php echo $item['title']; ?> <?php } ?> </td> </tr> </tbody> </table> </div>