Maybe it’s easier this way. Copy the following code to your functions.php
function showDatabaseColumnsLeaguemanager()
{
global $wpdb;
$tables = array($wpdb->leaguemanager, $wpdb->leaguemanager_teams, $wpdb->leaguemanager_matches, $wpdb->leaguemanager_stats);
foreach( $tables AS $table ) {
$results = $wpdb->get_results("SHOW COLUMNS FROM {$table}");
$columns = array();
foreach ( $results AS $result ) {
$columns[] = "<li>".$result->Field." ".$result->Type.", NULL: ".$result->Null.", Default: ".$result->Default.", Extra: ".$result->Extra."</li>";
}
echo "<p>Table ".$table."<ul>";
echo implode("", $columns);
echo "</ul></p>";
}
}
showDatabaseColumnsLeaguemanager();