Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated

Pull data from table?

6 years 4 months ago
  • Bill's Avatar
    Topic Author
  • Bill
  • Offline
  • Fresh Boarder
  • Posts: 42
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

JomSocial has an About Me field in user profile. Trying to pull that to the Hello Me module. I can get data, but it's the 1st row only, not for the specific user. Trying to get thespecific user's About Me data to module;

    <?php
        $db = JFactory::getDbo();
        $query = $db->getQuery(true);
        $query->select('value');
        $query->from($db->quoteName('mydb_community_fields_values'));
        $query->where($db->quoteName('field_id')." = ".$db->quote('4'));

        $db->setQuery($query);
        $result = $db->loadResult();
        ?>
        <?php echo $result; ?>

This almost works...

Ideas for only pulling user field?

Thanks,
Bill

6 years 4 months ago
Licenses:

HI, Bill.

Thank you for contacting us.
I presume that "About me" is your custom field. Try to use this to call it value: documentation.jomsocial.com/wiki/JomSoci...Custom_Profile_Field


- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
The following user(s) said Thank You: Bill
6 years 4 months ago
  • Bill's Avatar
    Topic Author
  • Bill
  • Offline
  • Fresh Boarder
  • Posts: 42
  • Thank you received: 0
Licenses:
JomSocial Active Socialize Expired

THANK YOU THANK YOU THANK YOU!

Yes, that was exactly what I needed!

Thanks again,
Bill

6 years 4 months ago
Licenses:

Hi, Bill.

I'm happy that it helped :)
Cheers :)


- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW