display dynamic content from flexi fields...

matthieu33
Topic Author
Offline
New Member

14 years 2 weeks ago #21820 by matthieu33

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

I know the border is very thin between custom dev and Flexicontent fields database use.

I mean item field from the database.

If you think it is too away from the regular Flexi support, just tell me, i would understand, but i am sure your skills and your global view about flexi would be a lot faster than me resolving this.

Thank you

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

ggppdk
Offline
Administrator

14 years 2 weeks ago #21821 by ggppdk

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

Can you not use the same code as for the date field in order to retrieve the value of this field?

-- 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 review. Thanks!

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

matthieu33
Topic Author
Offline
New Member

14 years 2 weeks 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

14 years 2 weeks 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

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