esedic
7/4/2014 - 2:39 PM

Joomla DB Query

Joomla DB Query

<?php 
	$db = JFactory::getDBO();
	$query = $db->getQuery(true);
	$query
	 ->select($db->quoteName(array('a.id')))
	 ->from($db->quoteName('#__content', 'a'))
	 ->join('INNER', $db->quoteName('#__categories', 'b') . ' ON (' . $db->quoteName('b.id') . ' = 38)');//static category id
	$db->setQuery($query);

	$results = $db->loadObjectList();
?>