$db = mysqli_connect("db5.sdu.dk","virksomhedsoekonomi","Pur65Gom38DoTugRyv");
mysqli_select_db($db, "virksomhedsoekonomi_db");
$query="select id,tittel,omtale from bogen where id=$bogid";
$result=mysqli_query($db, $query) or die(" Problem med $query: ".mysqli_error($db)." ");
$row=mysqli_fetch_array($result);
echo "$row[tittel] Af: ";
$query2="select * from forfatter where bid".$row['id']."='1'";
// echo $query2;
$result2=mysqli_query($db, $query2);
$index=0;
$delimiter=" ";
$count_elements=mysqli_num_rows($result2);
if ($count_elements > 1){ $delimiter=", ";}
while($row2=mysqli_fetch_array($result2)){
if(($count_elements > 1)&&($index==$count_elements-2)){
$delimiter=" og ";
}
if(($count_elements > 1)&&($index==$count_elements-1)){
$delimiter=" ";
}
echo "$row2[fornavn] $row2[efternavn]";
echo $delimiter;
$index++;
}
echo " ".nl2br($row['omtale']);
?>
|