Reply To: How to query posts filtered by custom field values from external database

• James

• June 19, 2016 at 9:44 pm

Hi @soko

Thanks for the post.

Yes this could be achieved by SQL, you would need something like this:

<?php
$wpdbtest_otherdb = new wpdb('username', 'password', 'shops', 'websitesql.whatever.com');
$wpdbtest_otherdb->show_errors();
$myshops = $wpdbtest_otherdb->get_results("SELECT * FROM shops");
foreach ($myshops as $myshop) {
echo $myshop->shopName . '<br />';
}
?>