Hente dataer fra flere tabeller
Hej.Hvordan udskriver jeg dataer fra mere end en tabel..?
Min kode ser således ud:
<?php
mysql_connect('host', 'brugernavn', 'password');
mysql_select_db("database");
echo "<table width=\"100%\" bgcolor=\"black\" cellpadding=\"2\" cellspacing=\"1\">";
echo "<tr>";
echo "<td width=\"33%\" bgcolor=\"#D4D4D4\">";
echo "<b>Titel</b>";
echo "</td><td width=\"34%\" bgcolor=\"#D4D4D4\">";
echo "<b>Album</b>";
echo '<td bgcolor="#D4D4D4"><a href="Slet.php?id='.$vis[id].'">slet</a>';
echo "</td></tr>";
$hent = mysql_query("SELECT * FROM lavigne ORDER BY album") or die(mysql_error());
while($vis = mysql_fetch_array($hent)){
echo "<tr>";
echo "<td width=\"33%\" bgcolor=\"#D4D4D4\">";
echo "<a href=\"vis.php?id=$vis[id]\">$vis[titel]</a>";
echo "</td><td width=\"34%\" bgcolor=\"#D4D4D4\">";
echo $vis[album];
echo '</td><td bgcolor="#D4D4D4"><a href="Slet.php?id='.$vis[id].'">slet</a>';
echo "</td></tr>";
}
echo "</table>";
?>
