Wordpress: Retrieve database table names and print them out

IGNONNETA

New Member
This should be fairly simple. I've crafted an SQL query that dumps all matching database table names to an array. I want to print them out, yet for some reason I cannot. Please help! Thank you in advance.Database tables are named: example_1, example_2, etc.My code:\[code\]$sql = "SHOW TABLES LIKE 'example_%'";$results = $wpdb->get_results($sql);\[/code\]Doing a print_r($results) shows that all the table names were successfully retrieved.Example output:\[code\]Array ( [0] => stdClass Object ( [Tables_in_wordpress (example_%)] => example_1 ) [1] => stdClass Object ( [Tables_in_wordpress (example_%)] => example_2 ) )\[/code\]So then I tried:\[code\]foreach($results as $res) { echo $res;}\[/code\]But no luck. How can I iterate through $results to print out each table name? Is there something like $results[0].value I could use to retrieve the values?
 
Top