Skip to Content Skip to Menu

Execute mysql query to populate cb_Field on Displa

13 years 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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