jeg er ved at lave en side, hvor man kan se alle de cd'ere jeg har.
har osse fået det meste til at virke nu.
men nu er jeg så stødt på et lille problem, hvis du kigger her :
http://fuckmyass.dyndns.biz/sikkersider/... skal jeg have en linje hvor man kan trykke på fx. a så lister alle de album der er med a, det skal lige siges at den henter alle oplysninger fra databasen, hvor databasen hedder dvd tabelen hedder albums og under den skal den sotere det fra name.
jeg vil have link på fra nul - å
håber der er en der kan hjælpe.
Koden ser sådan her ud :
------------------------
<?php
include('inc/Settings.inc');
include('inc/Db.inc');
include('inc/DrumRoll.inc');
include('inc/DVD.inc');
/* Slå databasen op */
$db = new MysqlDB();
$db->setupDb($database_setup);
/* Opret forbindelse til databasen*/
$db->Connect();
/* Opret drumroll */
$drumroll = new DrumRoll();
/* Hent alle DVD'er */
$dvds = $drumroll->rolldb(DVD,$db->PerformSQL("select * from dvd order by 1"));
/* luk forbindelse til databasen*/
$db->DisConnect();
?>
<?php
require("database.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>DiskCollection By FuckMyAss.dyndns.biz</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="dvd.css" rel="stylesheet" type="text/css">
</head>
<body class="cdlogo">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td height="112" align="center">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="70%" align="right">
</td>
<td height="112" align="left">
<form name ="searchform" action="search.php" metode="POST" class="content">
<strong class="sogebox">Enter Keyword:</strong><br />
<input name="searchtext" type="text" />
<br />
<input name="searchtype" type="radio" value = "album" checked/> <strong class="sogebox">Album Name</strong>
<input name="searchtype" type="radio" value = "song"/> <strong class="sogebox">Track Name</strong>
<br />
<br />
<input name="submit" type="submit" value = "submit"/>
<br />
<br />
<br />
<br />
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
</tr>
DET ER HER JEG VIL HAVE LINJEN FRA 0 - Å
<tr>
<td align="left" valign="top" id="content"> <br />
<p class="lineshift">All DVD's</p>
<table cellpadding="0" cellspacing="5" border="0">
<?php
/* List alle DVD'er*/
$max_rows = round(count($dvds) / $max_dvds_columns)+1;
for ($i=0;$i<$max_rows;$i++){
/* Hent en DVD */
$dvd = $dvds[$i];
print "<tr>\\n";
if ($i < count($dvds)) print "<td\\n><strong class=\\"menulink\\"><a href=\\"albums.php?dvd=" . $dvd->dvd_id . "\\">" . $dvd->name . "</a></strong> </td>\\n";
else print " <td\\n> </td>\\n";
for ($j=1;$j<$max_dvds_columns;$j++){
$i= $i + $max_rows;
$dvd = $dvds[$i];
if ($i < count($dvds)) print "<td\\n><strong class=\\"menulink\\"><a href=\\"albums.php?dvd=" . $dvd->dvd_id . "\\">" . $dvd->name . "</a></strong> </td>\\n";
else print "<td\\n> </td>\\n";
}
$i = ($i - ($max_rows * ($max_dvds_columns-1)));
print "</tr>\\n";
}
?>
</td>
</tr>
</table>
</body>
</html>
Hilsen Michael