Test Page


global $wpdb;
/* wpdb class should not be called directly.global $wpdb variable is an instantiation of the class already set up to talk to the WordPress database */ 

$result = $wpdb->get_results( "SELECT * FROM Client"); /*mulitple row results can be pulled from the database with get_results function and outputs an object which is stored in $result */

//echo "<pre>"; print_r($result); echo "</pre>";
/* If you require you may print and view the contents of $result object */

echo "ID"."  "."Name"."<br><br>";
foreach($result as $row)

 echo $row->id."  ".$row->name."<br>";

 /* Print the contents of $result looping through each row returned in the result */