Michael Legart <legart@daarligstil.dk> wrote in message
news:slrn9hmelr.8qt.legart@dustpuppy.worldonline.dk...
> On Mon, 4 Jun 2001 09:28:57 +0200, Ole Madsen <olem@post6.tele.dk> wrote:
> > Kan i sige mig hvordan man får order by med både gruppe og titel?
>
> select gruppe, titel from tabel order by gruppe, title;
Hvis jeg vil opdele det så jeg får hver gruppe for sig, hvad skal jeg gøre?
$sql = "SELECT * FROM $table_name ORDER BY date_acq DESC";
$result = @mysql_query($sql,$connection)
or die("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$format = $row['format'];
$title = $row['title'];
$artist_fn = $row['artist_fn'];
$artist_ln = $row['artist_ln'];
$rec_label = $row['rec_label'];
$my_notes = $row['my_notes'];
$date_acq = $row['date_acq'];
if ($artist_fn != "") {
$artist_fullname = trim("$artist_fn $artist_ln");
} else {
$artist_fullname = trim("$artist_ln");
}
if ($date_acq == "0000-00-00") {
$date_acq = "[unknown]";
}
$display_block .= "
<P><strong>$title</strong> ($artist_fullname)<br>
$my_notes <em>(acquired: $date_acq, format: $format)</em></p>
";
}
?>
<HTML>
<HEAD>
<TITLE>My Music (Ordered by Date Acquired)</TITLE>
</HEAD>
<BODY>
<H1>My Music</H1>
<? echo "$display_block"; ?>
Ole