I use two websites with their own databases on my server. One is wordpress personal website and other is opencart web shop. What i would like to do is fetch some of the data from opencart database and display it on my wordpress page.
My code inside wordpress file:
$mydb = new wpdb('user','pass','dbs','localhost');
$rows = $mydb->get_results("SELECT key FROM setting");
What I get is an empty array, although the column exist and it is filled with content.
Whats funny is that it works with some column names inside the same table. But not with the column i want.
That’s not a free hosted WordPress.com blog and we can’t help you here. If you don’t have a username account at WordPress.org click http://wordpress.org/support/ and register one on the top right hand corner of the page that opens, so you can post to the support forums there and receive advice from WordPress.org bloggers.