$loop = mysql_query(“SHOW users FROM $dbname”) or die (‘cannot select tables’);

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$row = mysql_query(“SELECT * FROM Users”, $link) or die (‘cannot select tables’);

while ($row = mysql_fetch_assoc($result)) {
    echo $row['firstname'];
    echo $row['lastname'];
    echo $row['address'];
    echo $row['age'];
}

mysql_free_result($result);

$sql = mysql_query("SELECT * FROM `users`");

while ($row = mysql_fetch_object($sql)) {
    echo $row->id . ' ' . $row->nickname . '<br />';
}

$loop = mysql_query('SELECT * FROM `users`') or die();

mysql_connect($mysql_host, $mysql_user, $user_password);