Use the data from one field to another

refacil
Topic Author
Offline
Premium Member

12 years 6 months ago #26162 by refacil

Use the data from one field to another was created by refacil

Hello friends:

How I can use the data from one field to another field?.

For example: the title of the article for posting videos in another field related to the article, but using the same text of the title.

Thanks

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

12 years 6 months ago #26163 by micker

Replied by micker on topic Use the data from one field to another

+1
i name it Alias field
it interesting thing but it difficult to optimize performance ...

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 6 months ago #26172 by ggppdk

Replied by ggppdk on topic Use the data from one field to another

Try something ... like ... this (replace 44 with your the id field (or add a parameter in the *.xml to get value from there) :

Code:

$db = &JFactory::getDBO();
$other_fieldid = 44;

$query = 'SELECT value FROM #__flexicontent_fields_item_relations AS f
	.' WHERE f.item_id = ' . $item->id
	.' AND f.field_id = ' . $other_fieldid
	;
$db->setQuery($query);
$field_value = $db->loadResultArray();

I advice you to get help from a PHP programmer

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

12 years 6 months ago #26175 by micker

Replied by micker on topic Use the data from one field to another

+1 i want to maried with php programmer :lol:

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 6 months ago #26176 by ggppdk

Replied by ggppdk on topic Use the data from one field to another

You are lucky your wife is not reading this forum,

Please Log in or Create an account to join the conversation.

refacil
Topic Author
Offline
Premium Member

12 years 6 months ago #26178 by refacil

Replied by refacil on topic Use the data from one field to another

It's posible can create a table of data to make queries from multiple fields? as would be done?

For example:
In the first column the id of the item, and in the next column the data to repeat in various fields.

Thanks to all php programmers (men and women) for the help.

Please Log in or Create an account to join the conversation.