help

Did you set up the database connection and query in the admin plugin settings?

After you do that then your user will be able to select results from your query in their account profile edit page.

In your template you will need to parse out the results of your query and the users selection to display the data.

What step were you stuck on?

fatal error: Call to undefined function MBlinkData()
Not sure what is going on, i can connect, but i cant get it to show anything. U say Parse? HUH what? I wish that things had actual step by step directions. A lot more detailed than what is on this page.

I am not even sure if this plugin will do what i really want it to do. it will do prol. half. My goal is to dynamically display DB data from another DB in my menu in table format or div.

Thanks,

I guess it is a little confusing.. The plugin will pull content from another database and will allow your users to choose which results will be displayed on their profile or template page.

For your error, did you get that right after installing the plugin or after you tried to integrate/parse the results?

I will make a new plugin that will just pull data and have it displayable (versus what it does now) and will update this plugin to be more descriptive.

My goal was to use your plugin to display 2 columns each from 2 separate tables. then take that and code and display the output into the menu structure as a table. so when i change names of products or prices or a particular server becomes unavailable the tables through out the site change without double or triple entry. all automatic…

My Example I have 4 Column | name | description | Monthly | annually

SELECT monthly, annually FROM tblpricing UNION SELECT name, description FROM tblproducts

This put everything under just 2 columns BUT the union worked PERFECT it only displayed just a single instance of my products each.

NOW my second effort
SELECT DISTINCT a.monthly, a.annually, b.name, b.description FROM tblpricing a INNER JOIN tblproducts b

this works great as it puts everything where i want it but NOW i have multiple instances of products cause there are other values for these columns which i do not use. So i was hoping i could use some code and ur plugin to make this work….The above code is hard coded into a template i did not use the plugin as its not working for me at all.

Hi,

I have downloaded the Plugin and entered all of my db dets etc.

What I’m now struggling with is how to call my results in the WP Page. I’m assuming it uses sort of shortcodes but not sure.
I’m starting with a simple select to begin with and hopefully once I can see the results I can start making my query a little more complicated.
Really appreciate some advice to get through this first step.

Thanks.

theNorth

Hi theNorth

After you have your query selected, you then log in with a user that will select which data to display in their edit profile page. Then on the profile template page you will parse out the data (in the actual template, with PHP not shortcode) you can use the example in the plugin to see how you can parse the data.

If you are trying to display the SQL data on a specific page that is not related to a user, this plugin does not do that at this time, but I do plan on making another version soon that does.

Hope that helps

https://www.ads-software.com/plugins/link-data-from-another-db/installation/
https://pastie.org/8406961 (parsing code that goes in your template)