Jacob Bunk Nielsen <spam@bunk.cc> wrote in message
news:m3adyucvtm.fsf@paven.bunk.cc...
> "Ole Madsen" <olem@post6.tele.dk> writes:
>
> Hent ampm ud fra databasen og sammenlign med den i stedet for
> date("a").
>
> Sig mig, prøvede du overhovedet selv eller spurgte du bare?
Her er mit forsøg, det jeg gerne vil er: am (dato) pm
Am og Pm skal være links som hentes i databasen
Ole
<?
$db_name = "spurgeon";
$table_name = "andagtmd";
$connection = @mysql_connect("localhost") or die("Couldn't connect.");
$dbs = @mysql_select_db($db_name, $connection) or die("Could'nt select
database");
$sql = "select * from $table_name
WHERE mdid = '".$HTTP_GET_VARS["andagtmdeng]."' ORDER BY id ";
$result = @mysql_query($sql, $connection) or die("Could'nt execute query");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$md = $row['md'];
$dato = $row['dato'];
$andagt = $row['andagt'];
$tekst = $row['tekst'];
$mdid = $row['mdid'];
$ampm = $row['ampm'];
$display_block .="
<a class=lt href=\"andagt_tekst.php?id={$row['id']}\">{$row['ampm(am)']}</a>
<a class=lt
href=\"andagt_tekst.php?id={$row['id']}\">{$row['ampm(pm)']}</a><br>\n";
};
?>
<HTML>
<HEAD>
<TITLE> type_Document_Title_here </TITLE>
</HEAD>
<BODY>
<? include"top.php"; ?><BR>
<? echo "$display_block" ?>