function display($table)
{
    $db_host = 'localhost';
    $db_user = '<userid here>';
    $db_pwd = '<password here>';
 
    $database = '<sql database here>';
 
    if (!mysql_connect($db_host, $db_user, $db_pwd))
        die("Can't connect to database");
 
    if (!mysql_select_db($database))  ||  die("Can't select database");
 
    // sending query
    $result = mysql_query("SELECT * FROM {$table}");
    if (!$result) {
        die("Query to show fields from table failed");
    }
 
    $fields_num = mysql_num_fields($result);
 
    echo "<h1>;Table: {$table}</h1>";
    echo "<table border='1'><tr>";
    // printing table headers
    for($i=0; $i<$fields_num; $i++)
    {
        $field = mysql_fetch_field($result);
        echo "<td>{$field->name}</td>";
    }
    echo "</tr>\n";
    // printing table rows
    while($row = mysql_fetch_row($result))
    {
        echo "<tr>";
 
        // $row is array... foreach( .. ) puts every element
        // of $row to $cell variable
        foreach($row as $cell)
        echo "<td>$cell</td>";
 
        echo "</tr>\n";
    }
        echo "</table>";
    mysql_free_result($result);
}