Skip to Content Skip to Menu

🏖 Summer has arrived! Start your summer right with our summer sale! Get 25% off professional and developer memberships with code SUMMER-2025!

Execute mysql query to populate cb_Field on Displa

13 years 10 months ago #176348 by zflexsoftware
Hi All,

I am looking for a way to dynamically perform a mysql query the currently viewing user and populate a custom field which has been added to a TAB.

I am sure that is an way to do this, but I have not found where to add the query for the custom field.

Can you guys give me a hand with this issue?

Thanks in advance....

- ZF

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

13 years 10 months ago #176349 by zflexsoftware
Replied by zflexsoftware on topic Re: Execute mysql query to populate cb_Field on Displa
This if for joomla 1.6 wth CB 1.7

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

13 years 10 months ago #176350 by zflexsoftware
Replied by zflexsoftware on topic Re: Execute mysql query to populate cb_Field on Displa
Well, I did find that field type should be "delimiter" type. THat did allow me to pull the current user name. :)

Now, I am just looking to add my sql query to my other database (on same system). Php is what I am looking for to pull the data and stuff it in the CB custom field.

Thanks - ZF

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
13 years 10 months ago #176352 by nant
The CB Query field plugin available for Professional members can do this.

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

13 years 10 months ago #176502 by zflexsoftware
Replied by zflexsoftware on topic Re: Execute mysql query to populate cb_Field on Displa
Okay...Great. Now I know that there is something to do the trick. I will read up on it and consider the professional membership.

Thanks Nant!!
- ZF

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

Moderators: beatnantkrileon
Powered by Kunena Forum