display dynamic content from flexi fields...

matthieu33
Topic Author
Offline
New Member

12 years 3 months ago #21823 by matthieu33

Replied by matthieu33 on topic display dynamic content from flexi fields...

Unfortunately no. It would have been too easy.

I think my SQL skills are simply a bit short on this one.
i am on something like this for now

Code:

$result = mysql_query("SELECT * FROM jos_flexicontent_fields_item_relations WHERE field_id='22'");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
     echo $row['value'];
     $MyUpdatedContent = "Contact : ".$row['value']."My content";
     
     // update Flexicontent introtext from jos_content where the item_id = id
     $query = "update jos_content t1 SET introtext ='".$MyUpdatedContent."' WHERE (SELECT COUNT(*) FROM jos_flexicontent_fields_item_relations t2 WHERE (t1.id=".$row['item_id'].") AND t2.value < CURDATE())";
mysql_query($query);
    }
    mysql_free_result($result);

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

ggppdk
Offline
Administrator

12 years 3 months ago #21832 by ggppdk

Replied by ggppdk on topic display dynamic content from flexi fields...

I am not sure, what you want to do, as the code that i would suggest for retrieving a field, would be the same as my previous post.

NOTE: that fields may serialize their value, and you can not unserialize inside an sql statement you will need PHP code between 2 sql statements.

If you make your project for profit and you want to help with custom development you can contact me with a PM after end of month, now i have little time.

Also if you had not done already, please post review in extension.joomla.org

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.