fejl i nyhedssystem
kode nr1.<HTML>
<HEAD>
<style type="text/css">
<!--
a.menu:link {text-decoration: none;}
a.menu:link:visited{text-decoration:none; color:#324458}
a.menu:link:hover {color:#FF3300;}
a.menu:link:hover:active {color:#FF3300;}
a {font-weight: none; text-decoration: underline;}
a:link {color:#324458;}
a:active {color:#FF3300;}
a:visited {color:#324458;}
a:hover {color:#FF3300;}
-->
</style>
<TITLE>Untitled Document</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<LINK HREF="/includes/css/css=racingzone.css" REL="stylesheet" TYPE="text/css">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
</HEAD>
<BODY BGCOLOR="#FFFFFF" LEFTMARGIN="0" TOPMARGIN="0" MARGINWIDTH="0" MARGINHEIGHT="0">
<TABLE WIDTH="817" HEIGHT="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD WIDTH="800" HEIGHT="60" VALIGN="TOP" CLASS="1dot"> <TABLE WIDTH="806" HEIGHT="65" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD HEIGHT="63" VALIGN="TOP"> </TD>
</TR>
<TR>
<TD HEIGHT="2" VALIGN="TOP"><IMG SRC="/pictures/dots=lodret.gif" WIDTH="800" HEIGHT="1"></TD>
</TR>
</TABLE>
<TABLE WIDTH="800" HEIGHT="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD WIDTH="180" HEIGHT="459" VALIGN="TOP" CLASS="text"><TABLE WIDTH="185" BORDER="0" CELLPADDING="1" CELLSPACING="0" BGCOLOR="#EAEAEA">
<TR>
<TD WIDTH="184" CLASS="text"><STRONG> .navigation</STRONG><SPAN CLASS="text1"><STRONG> <FONT COLOR="#FF3300">.:</FONT></STRONG></SPAN></TD>
</TR>
<TR>
<TD VALIGN="TOP"><IMG SRC="/pictures/dots=lodret3.gif" WIDTH="182" HEIGHT="1"></TD>
</TR>
</TABLE>
<TABLE WIDTH="185" BORDER="0" CELLPADDING="1" CELLSPACING="1" BGCOLOR="#F3F3F3" CLASS="text">
<TR>
<TD HEIGHT="22" VALIGN="BOTTOM"><A HREF="/index.php" CLASS="menu"><B> »
</B>Headquarters</A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="TOP"><A HREF="/situationreports.php" CLASS="menu"><B> »
</B>Situation reports</A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="MIDDLE"><A HREF="/specifications.php" CLASS="menu"><B> »
</B>Specifications</A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="MIDDLE"><A HREF="/chalk.php" CLASS="menu"><B> <FONT COLOR="#FF3300">»
</FONT></B><FONT COLOR="#FF3300">Chalk</FONT></A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="MIDDLE"><A HREF="/Communications.php" CLASS="menu"><B> »
</B>Communications</A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="MIDDLE"><A HREF="/Operations.php" CLASS="menu"><B> »
</B>Operations</A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="MIDDLE"><A HREF="/FileArchive.php" CLASS="menu"><B> »
</B>File Archive</A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="MIDDLE"><A HREF="/Contact.php" CLASS="menu"><B> »
</B>Contact</A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="MIDDLE"><A HREF="/Links.php" CLASS="menu"><B> »
</B>Links</A></TD>
</TR>
<TR>
<TD HEIGHT="14" VALIGN="TOP"><A HREF="/SecureUplink.php" CLASS="menu"><B> »
</B>Secure Uplink </A></TD>
</TR>
<TR>
<TD WIDTH="23" HEIGHT="21" ALIGN="CENTER" VALIGN="MIDDLE"><IMG SRC="/pictures/dots=lodret3.gif" WIDTH="182" HEIGHT="1" ALIGN="ABSMIDDLE"></TD>
</TR>
</TABLE>
<TABLE WIDTH="185" BORDER="0" CELLPADDING="0" CELLSPACING="0" BGCOLOR="#F3F3F3">
<TR>
<TD> </TD>
</TR>
</TABLE>
<TABLE WIDTH="182" BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD VALIGN="TOP"><IMG SRC="/pictures/dots=lodret3.gif" WIDTH="182" HEIGHT="1"></TD>
</TR>
</TABLE>
<TABLE WIDTH="185" BORDER="0" CELLPADDING="1" CELLSPACING="0" BGCOLOR="#EAEAEA">
<TR>
<TD CLASS="text"><STRONG> </STRONG><STRONG>.information
</STRONG><SPAN CLASS="text1"><STRONG> <FONT COLOR="#FF3300">.:</FONT></STRONG></SPAN></TD>
</TR>
<TR>
<TD VALIGN="TOP"><IMG SRC="/pictures/dots=lodret3.gif" WIDTH="182" HEIGHT="1"></TD>
</TR>
</TABLE>
<TABLE WIDTH="184" BORDER="0" CELLPADDING="1" CELLSPACING="1" BGCOLOR="#F3F3F3" CLASS="text">
<TR>
<TD WIDTH="184" HEIGHT="33">team-racingzone leder efter sponsor. <A HREF="/dwadasdda" CLASS="text">mere
info...</A></TD>
</TR>
<TR>
<TD HEIGHT="33" VALIGN="TOP" CLASS="text">team-racingzone samarbejder med <A HREF="http://www.morfars.dk" CLASS="links">morfars
legetøj</A> </TD>
</TR>
<TR>
<TD HEIGHT="3" VALIGN="TOP"><IMG SRC="/pictures/dots=lodret3.gif" WIDTH="182" HEIGHT="1"></TD>
</TR>
</TABLE>
<TABLE WIDTH="185" HEIGHT="100%" BORDER="0" CELLPADDING="1" CELLSPACING="1" BGCOLOR="#F3F3F3" CLASS="text">
<TR>
<TD WIDTH="321" HEIGHT="65"> </TD>
</TR>
</TABLE>
<BR>
<BR> <BR> <BR>
<BR>
<BR>
<BR>
</TD>
<TD WIDTH="620" VALIGN="TOP"><TABLE WIDTH="620" BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD WIDTH="10" HEIGHT="150" ALIGN="LEFT" VALIGN="TOP"><TABLE WIDTH="1" BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD><IMG SRC="/pictures/dots=vandret.gif" WIDTH="1" HEIGHT="171"></TD>
</TR>
</TABLE></TD>
<TD WIDTH="610" VALIGN="TOP"> </TD>
</TR>
</TABLE>
<TABLE WIDTH="620" BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD VALIGN="TOP"><IMG SRC="/pictures/dots=lodret2.gif" WIDTH="620" HEIGHT="1"></TD>
</TR>
</TABLE>
<TABLE WIDTH="620" HEIGHT="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="text">
<TR>
<TD WIDTH="10" HEIGHT="329" ALIGN="LEFT" VALIGN="TOP"><TABLE WIDTH="1" HEIGHT="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" BACKGROUND="/pictures/dots=bg.gif">
<TR>
<TD WIDTH="10" HEIGHT="249"> </TD>
</TR>
</TABLE></TD>
<TD WIDTH="599" ALIGN="CENTER" VALIGN="TOP"> <BR>
<BR>
<BR>
< <
<?php
include("../../../mysql.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($database);
$result = mysql_query("SELECT * FROM nyheder ORDER BY id DESC") or die(mysql_error());
$antal = mysql_num_rows($result);
if($antal == 0){
print "pis, ingen nyheder..";
} else {
while ($row = mysql_fetch_array($result)) {
$tekst = $row["besked"];
$tekst = htmlentities($tekst);
$tekst = str_replace("\n","<br>",$tekst);
$tekst = str_Replace(":)","<img src='smiley/icon_smile.gif'>",$tekst);
$tekst = str_Replace(":D","<img src='smiley/icon_smile_big.gif'>",$tekst);
$tekst = str_Replace("8D","<img src='smiley/icon_smile_cool.gif'>",$tekst);
$tekst = str_Replace(":I","<img src='smiley/icon_smile_blush.gif'>",$tekst);
$tekst = str_Replace(":P","<img src='smiley\icon_smile_tongue.gif'>",$tekst);
$tekst = str_Replace("}:)","<img src='smiley/icon_smile_evil.gif'>",$tekst);
$tekst = str_Replace(";)","<img src='smiley/icon_smile_wink.gif'>",$tekst);
$tekst = str_Replace("B)","<img src='smiley/icon_smile_blackeye.gif'>",$tekst);
$tekst = str_Replace(":o)","<img src='smiley/icon_smile_clown.gif'>",$tekst);
$tekst = str_Replace("8","<img src='smiley/icon_smile_8ball.gif'>",$tekst);
$tekst = str_Replace(":(","<img src='smiley/icon_smile_sad.gif'>",$tekst);
$tekst = str_Replace("8)","<img src='smiley/icon_smile_shy.gif'>",$tekst);
$tekst = str_Replace(":O","<img src='smiley/icon_smile_shock.gif'>",$tekst);
$tekst = str_Replace(":(!","<img src='smiley/icon_smile_angry.gif'>",$tekst);
$tekst = str_Replace("xx(","<img src='smiley/icon_smile_dead.gif'>",$tekst);
$tekst = str_Replace("|)","<img src='smiley/icon_smile_sleepy.gif'>",$tekst);
$tekst = str_Replace(":X","<img src='smiley/icon_smile_kisses.gif'>",$tekst);
$tekst = str_Replace("^","<img src='smiley/icon_smile_approve.gif'>",$tekst);
$tekst = str_Replace("V","<img src='smiley/icon_smile_dissapprove.gif'>",$tekst);
$tekst = str_Replace("?","<img src='smiley/icon_smile_question.gif'>",$tekst);
$tekst = preg_replace("/\[pre\](.*)\[\/pre\]/isU","<br><table border='0' width='auto' style='border: 1px solid black'><tr><td><b>\\1</b></td></tr></table>", $tekst);
$tekst = preg_replace("/\[u\](.*)\[\/u\]/isU","<u>\\1</u>", $tekst);
$tekst = preg_replace("/\[b\](.*)\[\/b\]/isU","<b>\\1</b>", $tekst);
$tekst = preg_replace("/\[i\](.*)\[\/i\]/isU","<i>\\1</i>", $tekst);
$tekst = preg_replace("/(\s|\")?([a-z0-9][a-z0-9.-_]*[a-z0-9]@[a-z0-9]([a-z0-9.-]*[a-z0-9])?\.[a-z]{2,4})/i","\\1<a href=\"mailto:\\2\">\\2</a>",$tekst);
$tekst = preg_replace("/(\s)?((f|ht)tp:\/\/[a-z0-9]([a-z0-9.-]*[a-z0-9])?\.[a-z]{2,4}(\/?[^<>\s]*[^\s<>.,])?)/i","\\1<a href=\"\\2\">\\2</a>",$tekst);
$tekst = preg_replace("/(\s)(www\.[a-z0-9]([a-z0-9.-]*[a-z0-9])?\.[a-z]{2,4}(\/?[^<>\s]*[^\s<>.,])?)/i","\\1<a href=\"http://\\2\">\\2</a>",$tekst);
$tekst = preg_replace("/\n/i","",$tekst,1);
?>
<TABLE ALIGN="center" CELLPADDING="0" CELLSPACING="0" STYLE="border: 1px solid black">
<TR>
<TD ALIGN="left" STYLE="border-bottom: 1px solid black" WIDTH="267">
<?=$row["title"]?>
by
<?=$row["navn"]?>
</TD>
</TR>
<TR>
<TD ALIGN="left" STYLE="border-bottom: 1px solid black" WIDTH="214" COLSPAN=3>
<?= date("l d. F Y @ H:i", $row["dato"]) ?>
</TD>
</TR>
<TR>
<TD COLSPAN=3 ALIGN=center>
<?=$tekst?>
</TD>
</TR>
</TABLE>
<BR>
<?php
}
}
?>
> ><BR>
<BR>
</TD>
<TD WIDTH="11" VALIGN="TOP"> </TD>
</TR>
</TABLE>
<BR>
</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
<BR>
<BR>
</TD>
<TD WIDTH="17" VALIGN="TOP" BACKGROUND="/pictures/border.gif"> </TD>
</TR>
</TABLE>
</BODY>
</HTML>
-----------------------------------------------------------
Kode nr2
<HTML>
<HEAD>
<TITLE>Untitled Document</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
</HEAD>
<BODY>
<?php
include("mysql.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($database);
$result = mysql_query("SELECT * FROM nyheder ORDER BY id DESC") or die(mysql_error());
$antal = mysql_num_rows($result);
if($antal == 0){
print "pis, ingen nyheder..";
} else {
while ($row = mysql_fetch_array($result)) {
$tekst = $row["besked"];
$tekst = htmlentities($tekst);
$tekst = str_replace("\n","<br>",$tekst);
$tekst = str_Replace(":)","<img src='smiley/icon_smile.gif'>",$tekst);
$tekst = str_Replace(":D","<img src='smiley/icon_smile_big.gif'>",$tekst);
$tekst = str_Replace("8D","<img src='smiley/icon_smile_cool.gif'>",$tekst);
$tekst = str_Replace(":I","<img src='smiley/icon_smile_blush.gif'>",$tekst);
$tekst = str_Replace(":P","<img src='smiley\icon_smile_tongue.gif'>",$tekst);
$tekst = str_Replace("}:)","<img src='smiley/icon_smile_evil.gif'>",$tekst);
$tekst = str_Replace(";)","<img src='smiley/icon_smile_wink.gif'>",$tekst);
$tekst = str_Replace("B)","<img src='smiley/icon_smile_blackeye.gif'>",$tekst);
$tekst = str_Replace(":o)","<img src='smiley/icon_smile_clown.gif'>",$tekst);
$tekst = str_Replace("8","<img src='smiley/icon_smile_8ball.gif'>",$tekst);
$tekst = str_Replace(":(","<img src='smiley/icon_smile_sad.gif'>",$tekst);
$tekst = str_Replace("8)","<img src='smiley/icon_smile_shy.gif'>",$tekst);
$tekst = str_Replace(":O","<img src='smiley/icon_smile_shock.gif'>",$tekst);
$tekst = str_Replace(":(!","<img src='smiley/icon_smile_angry.gif'>",$tekst);
$tekst = str_Replace("xx(","<img src='smiley/icon_smile_dead.gif'>",$tekst);
$tekst = str_Replace("|)","<img src='smiley/icon_smile_sleepy.gif'>",$tekst);
$tekst = str_Replace(":X","<img src='smiley/icon_smile_kisses.gif'>",$tekst);
$tekst = str_Replace("^","<img src='smiley/icon_smile_approve.gif'>",$tekst);
$tekst = str_Replace("V","<img src='smiley/icon_smile_dissapprove.gif'>",$tekst);
$tekst = str_Replace("?","<img src='smiley/icon_smile_question.gif'>",$tekst);
$tekst = preg_replace("/\[pre\](.*)\[\/pre\]/isU","<br><table border='0' width='auto' style='border: 1px solid black'><tr><td><b>\\1</b></td></tr></table>", $tekst);
$tekst = preg_replace("/\[u\](.*)\[\/u\]/isU","<u>\\1</u>", $tekst);
$tekst = preg_replace("/\[b\](.*)\[\/b\]/isU","<b>\\1</b>", $tekst);
$tekst = preg_replace("/\[i\](.*)\[\/i\]/isU","<i>\\1</i>", $tekst);
$tekst = preg_replace("/(\s|\")?([a-z0-9][a-z0-9.-_]*[a-z0-9]@[a-z0-9]([a-z0-9.-]*[a-z0-9])?\.[a-z]{2,4})/i","\\1<a href=\"mailto:\\2\">\\2</a>",$tekst);
$tekst = preg_replace("/(\s)?((f|ht)tp:\/\/[a-z0-9]([a-z0-9.-]*[a-z0-9])?\.[a-z]{2,4}(\/?[^<>\s]*[^\s<>.,])?)/i","\\1<a href=\"\\2\">\\2</a>",$tekst);
$tekst = preg_replace("/(\s)(www\.[a-z0-9]([a-z0-9.-]*[a-z0-9])?\.[a-z]{2,4}(\/?[^<>\s]*[^\s<>.,])?)/i","\\1<a href=\"http://\\2\">\\2</a>",$tekst);
$tekst = preg_replace("/\n/i","",$tekst,1);
?>
<TABLE ALIGN="center" CELLPADDING="0" CELLSPACING="0" STYLE="border: 1px solid black">
<TR>
<TD ALIGN="left" STYLE="border-bottom: 1px solid black" WIDTH="267">
<?=$row["title"]?>
by
<?=$row["navn"]?>
</TD>
</TR>
<TR>
<TD ALIGN="left" STYLE="border-bottom: 1px solid black" WIDTH="214" COLSPAN=3>
<?= date("l d. F Y @ H:i", $row["dato"]) ?>
</TD>
</TR>
<TR>
<TD COLSPAN=3 ALIGN=center>
<?=$tekst?>
</TD>
</TR>
</TABLE>
<BR>
<?php
}
}
?>
</BODY>
</HTML>
-----------------------------------------------------------
Dette er en del af et nyhedssystem. hvis jeg åbner kode nr1 får jeg følgende fejl
< <
Warning: main() [function.main]: Unable to access ../../../mysql.php in /web/www/frac/users/teamracingzone/includes/pages/secureuplink/index.php on line 160
Warning: main(../../../mysql.php) [function.main]: failed to create stream: No such file or directory in /web/www/frac/users/teamracingzone/includes/pages/secureuplink/index.php on line 160
Warning: main() [function.main]: Failed opening '../../../mysql.php' for inclusion (include_path='.:/usr/local/share/pear') in /web/www/frac/users/teamracingzone/includes/pages/secureuplink/index.php on line 160
Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'nobody@localhost' (Using password: NO) in /web/www/frac/users/teamracingzone/includes/pages/secureuplink/index.php on line 161
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user: 'nobody@localhost' (Using password: NO) in /web/www/frac/users/teamracingzone/includes/pages/secureuplink/index.php on line 162
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /web/www/frac/users/teamracingzone/includes/pages/secureuplink/index.php on line 162
Warning: mysql_query() [function.mysql-query]: Access denied for user: 'nobody@localhost' (Using password: NO) in /web/www/frac/users/teamracingzone/includes/pages/secureuplink/index.php on line 163
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /web/www/frac/users/teamracingzone/includes/pages/secureuplink/index.php on line 163
Access denied for user: 'nobody@localhost' (Using password: NO)
men hvis jeg derimod åbner kode nr2 virker det helt fint.
Det eneste jeg har gjordt er at jeg har smidt kode nr2 hen i nr1, men det virker åbenbart ikke. Hvad er der galt ?
