Code:
Ich brauch ein srrcipt der mir den aus der db aus gelesenen text von mir aus >>hallo :-)<<
und das er mir dann den :-) in ein
:-) macht.
Code:
<?
$link = mysql_connect('localhost','web14','123456');
$db = mysql_select_db('usr_web14_1') or die (mysql_error() );
$sql = "SELECT * from News ORDER BY ts DESC LIMIT 0,4";
$res = mysql_query($sql);
?>
<img src='_images/smilies/grenade.gif'>
<html>
<head>
<title>Farcry-Mod</title>
</head>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<style type="text/css">
<!--
frame, select, textarea
{ color:#000000; }
.Bereich, .Feld
{ background-color:#DCE3FF;}
-->
</style>
<style type="text/css">
<!--
.textnormal2 {
font-family: Arial;
font-size: 11px;
font-style: normal;
line-height: normal;
font-weight: normal;
font-variant: normal;
color: #FFFFFF;
text-decoration: none;
}
.textnormal {
font-family: Arial;
font-size: 11px;
font-style: normal;
line-height: normal;
font-weight: normal;
font-variant: normal;
color: #FFFFFF;
text-decoration: none;
}
.menuetext {
font-family: arial;
font-size: 12px;
font-style: normal;
line-height: normal;
font-weight: normal;
font-variant: normal;
color: #FFFFFF;
}
.menuetext:hover {
color: #548B69;
}
.test {
background-color: #3C5C48;
background-image: url(_images/backgraund.jpg);
background-position: 0 0;
background-repeat: no-repeat;
}
.bild {
border:1px solid #333333;
}
.loginfield2
{ background-color:#3C5C48;
font-family: Arial;
font-size: 10px;
color: #FFFFFF;
border:0px solid #333333;
height: 15px;
width: 50px; }
.loginfield
{ background-color:#548B69;
font-family: Arial;
font-size: 10px;
color: #FFFFFF;
border:1px solid #333333;
height: 15px;
width: 50px; }
-->
</style>
<body class="test" bgcolor="#3C5C48" LEFTMARGIN=0 topMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 >
<div style="position:absolute; top:160px; left:175px; ">
<?
while ($row = mysql_fetch_assoc($res))
{
?>
<table width="650" border="0" cellpadding="0" cellspacing="0" bgcolor="548B69" width="560" border="0" cellspacing="0" cellpadding="2" style="border-style:solid; border-width:1px; border-color:#000000;">
<img class="bild" src="<?=$row["symbol"];?>">
<tr bgcolor="3C5C48">
<td class="menuetext"><?=$row["title"];?><img src="spacer.gif" height="1" width="450" ><a class="menuetext" href="mailto:<?=$row["email"];?>">von: <?=$row["autor"];?></a></td><td class="menuetext"><?=$row["datum"];?></td>
</tr>
<tr>
<td class="textnormal"><?=$row["text"];?></td><td></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="650" border="0" cellpadding="0" cellspacing="0" width="560" border="0" cellspacing="0" cellpadding="2" >
<tr>
<td colspan="3"><img width="560" height="1" src="spacer.gif"</td><td><a href="#" class="menuetext">Bemerkungen</a></td>
</tr>
</table>
<?
}
?>
</div>
<div style="position:absolute; top:409px; left:0px; ">
<table width="119 border="0" cellpadding="0" cellspacing="0" bgcolor="3C5C48" border="0" cellspacing="0" cellpadding="0" style="border-style:solid; border-width:1px; border-color:#000000;">
<tr>
<td class="menuetext">Userlogin</td>
</tr>
<tr>
<td class="textnormal"> Username: </td><td><input name="title" class="loginfield" type="text"></td>
</tr>
<tr>
<td class="textnormal"> Passwort: </td><td><input name="name" class="loginfield" type="password"></td>
</tr>
<tr>
<tr>
<td><a class="textnormal2" href="reg.php"> Rregistrieren</a> </td><td><input frameborder="0" class="loginfield2" name="login" value="Login" type="submit"</td>
</tr>
</table>
</div>
<table style="position:absolute; top:104px; left:17px; ">
<tr>
<td><a href="index.php" onMouseOver="MM_swapImage('Image1','','_images/menu1_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu1.gif" name="Image1" border="0" id="Image1"></a></td>
</tr>
</table>
<table style="position:absolute; top:125px; left:17px; ">
<tr>
<td><a href="javascript:;" onMouseOver="MM_swapImage('Image2','','_images/menu2_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu2.gif" name="Image2" border="0" id="Image2"></a></td>
</tr>
</table>
<table style="position:absolute; top:146px; left:17px; ">
<tr>
<td><a href="javascript:;" onMouseOver="MM_swapImage('Image3','','_images/menu3_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu3.gif" name="Image3" border="0" id="Image3"></a></td>
</tr>
</table>
<table style="position:absolute; top:167px; left:16px; ">
<tr>
<td><a href="javascript:;" onMouseOver="MM_swapImage('Image4','','_images/menu4_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu4.gif" name="Image4" border="0" id="Image4"></a></td>
</tr>
</table>
<table style="position:absolute; top:188px; left:17px; ">
<tr>
<td><a href="javascript:;" onMouseOver="MM_swapImage('Image5','','_images/menu5_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu5.gif" name="Image5" border="0" id="Image5"></a></td>
</tr>
</table>
<table style="position:absolute; top:209px; left:17px; ">
<tr>
<td><a href="javascript:;" onMouseOver="MM_swapImage('Image6','','_images/menu6_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu6.gif" name="Image6" border="0" id="Image6"></a></td>
</tr>
</table>
<table style="position:absolute; top:92px; left:0px; ">
<tr>
<img src="_images/menu_left.gif" name="menu_left" border="0" ></a></td>
</tr>
</table>
<table style="position:absolute; top:230px; left:16px; ">
<tr>
<td><a href="javascript:;" onMouseOver="MM_swapImage('Image7','','_images/menu7_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu7.gif" name="Image7" border="0" id="Image7"></a></td>
</tr>
</table>
<table style="position:absolute; top:251px; left:16px; ">
<tr>
<td><a href="javascript:;" onMouseOver="MM_swapImage('Image8','','_images/menu8_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu8.gif" name="Image8" border="0" id="Image8"></a></td>
</tr>
</table>
<table style="position:absolute; top:272px; left:16px; ">
<tr>
<td><a href="javascript:;" onMouseOver="MM_swapImage('Image9','','_images/menu9_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu9.gif" name="Image9" border="0" id="Image9"></a></td>
</tr>
</table>
<table style="position:absolute; top:293px; left:16px; ">
<tr>
<td><a href="admin_login.html" onMouseOver="MM_swapImage('Image10','','_images/menu10_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu10.gif" name="Image10" border="0" id="Image10"></a></td>
</tr>
</table>
</body>
</html>
