Skip to content

Instantly share code, notes, and snippets.

@folmert

folmert/joomla_sql_select.php

Created June 9, 2015 09:03
Show Gist options
  • Save folmert/f9e6cc05ec96a3dbcafa to your computer and use it in GitHub Desktop.
Save folmert/f9e6cc05ec96a3dbcafa to your computer and use it in GitHub Desktop.
Download ZIP
joomla_sql_select
Raw
joomla_sql_select.php
$db =& JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('value');
$query->from('sls37_djc2_items_extra_fields_values_text');
$query->where('item_id ='.$itemId);
$query->AND('field_id ='.$field->id);
$db->setQuery($query);
$fieldValue = $db->loadObjectList();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment