<?php
$host = '162.55.65.66';
$db   = 'flightbo_game';
$user = 'flightbo_game';
$pass = 'flightbo_game';
$conn = mysqli_connect($host, $user, $pass, $db);
$tables = ['categories', 'leagues', 'matches', 'questions', 'options'];
foreach ($tables as $t) {
    echo "TABLE $t:\n";
    $res = mysqli_query($conn, "DESCRIBE `$t`");
    if($res){
        while($r = mysqli_fetch_assoc($res)) {
            echo " - " . $r['Field'] . "\n";
        }
    } else {
        echo " Not found\n";
    }
}
mysqli_close($conn);
