Hallo habe ein Problem mit meiner Datenbank und zwar bekomme ich sie nicht ganz angezeigt und finde nicht heraus wieso das kommt.
$conn=mysql_connect("$host","$user","$pw");
mysql_select_db("$db",$conn);
$abfrage="select Titel,Interpret,Preis,Spieldauer,Qualität,Label,Bild,Warenkorb from Katalog";
$ergebnis=mysql_query($abfrage,$conn);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<title>
Musik Download Center
</title>
<link rel="stylesheet" href="style.css" type="text/css" media="screen" />
</head>
<body>
<?
session_start();
if (isset($_SESSION['txtuser']))
echo "Login as : ".$_SESSION['txtuser'];
else
echo "nicht eingeloggt";
?>
<div id="container">
<!-- Start of Page Title -->
<div id="page_title">
<h1><span>The Music Website</span>Musik Download Center </h1>
</div>
<!-- End of Page Title -->
<div id="header_image"></div>
<!-- Start of Page Header -->
<div id="header_container_left">
<div id="header_container_right">
<div id="header_container">
<div id="page_header"><!-- Start of Header Punchline -->
<!-- End of Header Punchline -->
<!-- Start of Header Navigation Menu -->
<div id="header_menu">
<ul>
<li id="menu_4"><a href="Hauptpage.php"><b>Home</b></a></li>
<li id="menu_1"><a href="MusikDownloadCenter.php"><b>Katalog</b></a></li>
<li id="menu_2"><a href="Informationen.htm"><b>Informationen</b></a></li>
<li id="menu_3"><a href="Links.htm"><b>Links</b></a></li>
</ul>
</div>
<!-- End of Page Header : Menu -->
<!-- Start of Header Links -->
<!-- End of Header Links -->
<div> <table width="144" border="0">
<tr>
<td width="138" height="20">
<? if ($_SESSION['txtuser'] == Jerome) { ?>
<form id="form1" method="post" action="EinstellungenTabelle.php">
<input type="submit" name="Submit" value="Einstellungen Katalog" />
</form>
<? } ?>
</td>
</tr>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- End of Page Header -->
<!-- Start of Main Content -->
<div id="maincontent_container">
<table width="557" border="1">
<tr>
<td width="51"><strong>Titel</strong></td>
<td width="67"><strong>Interpret</strong></td>
<td width="67"><strong>Preis</strong></td>
<td width="70"><strong>Spieldauer</strong></td>
<td width="53"><strong>Qualität</strong></td>
<td width="51"><strong>Label</strong></td>
<td width="105"><strong>Bild</strong></td>
<td width="41"><strong>Warenkorb</strong></td>
</tr>
<?
while($zeilen = mysql_fetch_assoc($resultat))
{
echo "<tr> <td>$zeilen->Titel </td> <td>$zeilen->Interpret </td> <td>$zeilen->Preis </td> <td>$zeilen->Spieldauer </td> <td> $zeilen->Qualität</td> <td>$zeilen->Label</td> <td>$zeilen->Bild</td> <td>$zeilen->Warenkorb</td></tr>";
}
?>
</table>
</div>
<!-- End of Main Content -->
<!-- Start of Page Footer -->
<div id="page_footer"></div>
<!-- End of Page Footer -->
</div>
</body>
</html>
