Hente data fra MySQL - how?

connectiion....
$resultat = mysql_query("select felt1, felt2 from tabel");
while ($raekke = mysql_fetch_array($resultat)) {
  echo "Felt1: ".$raekke['felt1'].
        " Felt2: ".$raekke['felt2']."<br />";
}

prøv at lege lidt med det her:
<?
//connect til database

$query = mysql_query("SELECT * FROM tabel");

//close database

print "<table>\n";
$kolonenavne = 0;
while ($row = mysql_fetch_assoc($query)) {   
    print "<tr>\n";
    if($kolonenavne == 0){
    foreach($row as $key => $value)
      print "<td>".$key."</td>\n";
      $kolonenavne = 1;
    }else{
        foreach($row as $key => $value)
      print "<td>".$value."</td>\n";
    }
    print "</tr>\n";
} 

print '</table>';
?>

Lidt a'la' hindu_skp

$resultat = mysql_query("SELECT `felt1`, `felt2` FROM `tabel`") or die (mysql_error());
if(mysql_num_rows($resultat) !=0) {
echo"Indhold af query:";
while($raekke = mysql_fetch_object($resultat)) {
  echo "<br />\nFelt1: ". $raekke->felt1 .
        ", Felt2: ". $raekke->felt2;
    }
}else{
echo"Ingen info at hente fra DB!";
}