Hente links fra DB
Hvad gør jeg galt i nedenstående script?Det er en links side, der henter URLs fra en DB. Det er meningen at den skal hente URL www.something.dk (link) + link beskrivelse (linkDesc) ind på siden og lave en ny række i tabellen for hvert link der bliver hentet
Her er scriptet håber nogen kan hjælpe:
<?php
// This page will list all of the items
// from the items table. Each item will have
// a link to add it to the cart
include("db.php");
// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
$result = mysql_query("SELECT * FROM links ")or die(mysql_error());
$link = mysql_fetch_array($result);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Jernbanemaerker</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {color: #89744B}
-->
</style>
<script language="javascript" type="text/javascript">
window.onload = function(){update();setInterval('update()',60000)}
function update(){
var d = new Date();
document.getElementById('minSpan').innerHTML = d.format("hh:uu | \\d. d. mmmm");
}
</script>
<script language="javascript" type="text/javascript" src="roenvingDate.js"></script>
</head>
<body bgcolor="#D8C5A3">
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="right" valign="top">
<td width="900" height="143" class="top"><?php include("menu.php"); ?></td>
</tr>
<tr>
<td height="503" valign="top" class="body" bgcolor="#F2E3C8"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="245" height="349" valign="top" class="left"> </td>
<td width="655" align="center" valign="top" class="middle"><p> </p>
<table width="93%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" class="style2"><h1>Links til andre relevante hjemmesider</h1>
<p> </p></td>
</tr>
<tr>
<?php
while($row = mysql_fetch_array($result))
{
?>
<td align="left" valign="top" class="style2"><p><a href="http://<?php echo $row["link"]; ?>" target="_blank"><?php echo $row["link"]; ?></a></p>
<p><?php echo $row["linkDesc"]; ?></p></td>
</tr>
<tr>
<td height="15" align="left" valign="middle" class="style2"><img src="gfx/prik.jpg" width="100%" height="1"></td>
</tr>
<?php
}
?>
</table>
<p> </p></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
