<?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>
- Output for 7.1.0 - 7.1.33, 7.2.0 - 7.2.34, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
preferences:
186.25 ms | 403 KiB | 225 Q