Wordpress-Using wpdb to connect to a separate database

Below is the code to connect to a separate database in wordpress.

?

1 2 3 4 5 6 7

$mydb = new wpdb('username','password','database','localhost'); $rows = $mydb->get_results("select Name from my_table"); echo "<ul>"; foreach ($rows as $obj) :    echo "<li>".$obj->Name."</li>"; endforeach; echo "</ul>";