title: getting RS Eevents category name from Joomla database
body: <p>I'm trying to get the category details from the joomla database for RSEvents. Can anyone shed any light on why this isn't working:</p>
  
  <pre><code>function _getCategorySlug($value) {
      // Get a db connection.
      $db = JFactory::getDbo();    
      // Create a new query object.
      $query = $db-&gt;getQuery(true);    
      // Select all articles for users who have a username which starts with 'a'.
      // Order it by the created date.
      // Note by putting 'a' as a second parameter will generate `#__content` AS `a`
      $query
          -&gt;select($db-&gt;quoteName(array('a.*', 'b.id', 'b.ide')))
          -&gt;from($db-&gt;quoteName('#__categories', 'a'))
          -&gt;join('INNER', $db-&gt;quoteName('#__rseventspro_taxonomy', 'b') 
          . ' ON (' . $db-&gt;quoteName('a.id') . ' = ' . $db-&gt;quoteName('b.id') . ')')
          -&gt;where($db-&gt;quoteName('b.ide') . ' = '.$db-&gt;quote($value));     
      // Reset the query using our newly populated query object.
      $db-&gt;setQuery($query);   
      // Load the results as a list of stdClass objects (see later for more options on retrieving data).
      $results = $db-&gt;loadObjectList();
  }
  </code></pre>