... that my data is inaccurate as the last row of each grouped data has been changed to NULL. Also note how the actual select query is pulling data from my CTE in its post-formatted form. I perform all the ...
... from within a Joomla! extension using the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a sample table:
$db =& JFactory::getDBO();
$sql_utf8 = "set names 'utf8'";
$db->setQuery( ...
... where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error:
#145 - Table './jos_k2_items' is marked as crashed and should be repaired ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.