[Corrected FAQ] Retrieving item data e.g. for use in RSforms

I'm sorry but the code in FAQ doesn't work for me:

I tried to get in RS field Default value email field and also text field but it get nothing :

//<code>
$db = & JFactory::getDBO();
// Set a different item id if you don't want the current item ...
$fcitem_id= JRequest::getInt('id',0);
$fccat_id= JRequest::getInt('cid',0);
$view= JRequest::getVar('view');
if ($view!='items' && $view!='item' && $view!='article') {
return "not in items view";
}

$field_id=19; // CHANGE THIS TO THE ID OF YOUR FIELD
if ($fcitem_id) {
$query = 'SELECT c.title, c.alias, f.value '
.'FROM '.'#'.'__content AS c '
.' LEFT JOIN '.'#'.'__flexicontent_fields_item_relations AS f'
.' ON f.item_id = i.id AND f.field_id='.(int)$field_id
.'WHERE c.id = ' . $fcitem_id;

$db->setQuery($query);
$itemdata = $db->loadObject();
$item_title = $itemdata->title;
}
return $itemdata->value;
//</code>

best regards

Try changing
.' ON f.item_id = i.id AND f.field_id='.(int)$field_id
to
.' ON f.item_id = c.id AND f.field_id='.(int)$field_id

the field is always empty
thanks

Ok put these lines at the top:

AND AFTER:
$itemdata = $db->loadObject();
to see if there is a DB query error,

also make sure the field id is correct

IT WORKS !!!

thank you so it was just a f...ing space that was needed before WHERE

I put the code in order you change it in the faq

//<code>
$db = & JFactory::getDBO();
// Set a different item id if you don't want the current item ...
$fcitem_id= JRequest::getInt('id',0);
$fccat_id= JRequest::getInt('cid',0);
$view= JRequest::getVar('view');
if ($view!='items' && $view!='item' && $view!='article') {
return "not in items view";
}

$field_id=19; // CHANGE THIS TO THE ID OF YOUR FIELD
if ($fcitem_id) {
$query = 'SELECT c.title, c.alias, f.value '
.'FROM '.'#'.'__content AS c '
.' LEFT JOIN '.'#'.'__flexicontent_fields_item_relations AS f'
.' ON f.item_id = c.id AND f.field_id='.(int)$field_id
.' WHERE c.id = ' . $fcitem_id;

$db->setQuery($query);
$itemdata = $db->loadObject();
$item_title = $itemdata->title;
}
return $itemdata->value;
//</code>

thanks

Fixed the FAQ article to have spaces so that DB query does not fail

Regards