Let Joomla and MySQL interact!

I often need a quick and easy few lines to retrieve some data from MySQL using Joomla without all the MVC nonsense that usually goes about this topic. So here is how I do it! [code lang=”php”] $dbSEL = JFactory::getDbo(); $dbSEL->setQuery(“SELECT MAX(`start_price`) FROM #__some_table”); $dbSEL->query(); echo $dbSEL->fetchRow(); [/code] As you Read more…

By Andrew Odendaal, ago