Kan nogen se hvad fejlen er når jeg skal hente mit billed fra min database tabel. jeg har prvet en masse nu. jeg sætter tre *** ud for den linie som jeg ikke kan få til at virke....
<head>
<LINK REL="SHORTCUT ICON" HREF="
http://localhost/joy-palaze/img/jpe.ico"></head>
<?php
echo "<title>Joy Palaze Entertainment</title>";
?>
<style type="text/css">
<!--
.style1 {
font-size: x-small;
font-family: "Book Antiqua", "Bookman Old Style", "Comic Sans MS", Haettenschweiler;
}
fieldset {
color: navy;
border-color:#0066FF;
width: 145;
}
legend {
color: #FF0000;
}
hr {
color:#0066FF;
width:300;
}
-->
</style><table width="900" height="635" border="0" align="center" cellpadding="0" cellspacing="0" background="../img/baggrund.gif">
<tr>
<td height="120" colspan="3"> </td>
</tr>
<tr>
<td width="182" height="100" align="center" valign="bottom">
<a href="../index.php"><img src="../img/logo.gif" /></a> </td>
<td rowspan="2" valign="top"><br><?php
mysql_connect(localhost, hansen, patricia) or die(mysql_error());
mysql_select_db(palaze) or die(mysql_error());
$id = ( !empty( $_GET['id'] ) ? mysql_real_escape_string( $_GET['id'] ) : 0 );
$sql = sprintf( "
SELECT
*
FROM
nyheder
WHERE
id = '%s'
"
,$id
);
$qh = mysql_query( $sql ) or die ( mysql_error() );
if ( mysql_num_rows( $qh ) > 0 )
{
$row = mysql_fetch_assoc( $qh );
echo "<table border=\"0\" width=\"250\" align=\"center\"><tr><td colspan=\"2\"><center><h2>$row[overskrift]</h2></center><br><hr></td>
*** <tr><td><img src=\"../img/".$row['billed']."\"></td><td>$row[beskrivelse]</p></td></table>";
echo "<center><a href=\"../index.php\">Tilbage til forsiden</a></center>";
}
else
{
echo "Ingen nyhed.";
}
?></td>
<td width="239" valign="top"><br />
Profiler: <?php
mysql_connect(localhost, hansen, patricia) or die(mysql_error());
mysql_select_db(palaze) or die(mysql_error());
$query = mysql_query("SELECT COUNT(*) FROM profil");
$antal = mysql_result($query, 0);
echo $antal;
?><br />
Forum: <?php
mysql_connect(localhost, hansen, patricia) or die(mysql_error());
mysql_select_db(palaze) or die(mysql_error());
$query = mysql_query("SELECT COUNT(*) FROM forum");
$antal = mysql_result($query, 0);
echo $antal; ?>
<br />
Online profiler: <?php ?><br>
Jokes: <?php
mysql_connect(localhost, hansen, patricia) or die(mysql_error());
mysql_select_db(palaze) or die(mysql_error());
$query = mysql_query("SELECT COUNT(*) FROM jokes");
$antal = mysql_result($query, 0);
echo $antal;
?> </td>
</tr>
<tr>
<td valign="top"><p>
<fieldset>
<legend>Start</legend>
<a href="../index.php">Forside</a><br />
Login<br />
Forum<br />
Opret Bruger<br>
</fieldset>
<p>
<fieldset>
<legend>Sjov</legend>
Jokes<br />
Spil<br />
Download<br />
Chat
</fieldset>
<p>
<fieldset>
<legend>Administration</legend>
Admin Login<br />
<a href="news.php">Tilføj nyhed</a><br />
<a href="feedback.php">Feedback</a><br />
Om os<br />
Send mail
</fieldset> </td>
<td align="center" valign="top">
<fieldset>
<legend>Nyheder</legend>
<?php
mysql_connect(localhost, hansen, patricia) or die(mysql_error());
mysql_select_db(palaze) or die(mysql_error());
$sql = "
SELECT
*
FROM
nyheder
ORDER BY
dato DESC
LIMIT 3
";
$qh = mysql_query( $sql ) or die ( mysql_error() );
if ( mysql_num_rows( $qh ) > 0 )
{
while ( $row = mysql_fetch_assoc( $qh ) )
{
echo '<a href="vis_nyhed.php?id=' . $row['id'] . '">' . $row['overskrift'] . '</a><br>';
}
}
else
{
echo "Ingen nyheder.";
}
?>
</fieldset>
<p>
<fieldset>
<legend>Opdatering</legend>
her kommer vores<br /> opdateringer.
</fieldset>
<p>
<fieldset>
<legend>Sponsere</legend>
Her kommer vores<br />
sponsere fra en <br />
database.
</fieldset> </td>
</tr>
<tr >
<td height="40" colspan="3" align="center" valign="top"><span class="style1">Joy Palaze Entertainment<br>
Copyright © year 2005 </span></td>
</tr>
</table>
på forhånd tak
