Bild will die größe nicht nehmen. hallo zusammen. ich habe ein kleines problem wo ich anstehe. ich check das heute nicht. hoffe es kann mir wer helfen.
Ich möchte in diesem script <img border=0 src=\"".$row_rs['Filepfad']."\"> das das bild in 108x83 angezeigt wird. ich habe euch mal den ganzen script reingemacht.
danke mal im vorraus. blax
<?php require_once('connections/toscanadb.php'); ?>
<?php
mysql_select_db($database_toscanadb, $toscanadb);
$query_Recordset1 = "SELECT * FROM copyright";
$Recordset1 = mysql_query($query_Recordset1, $toscanadb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<?PHP
mysql_select_db($database_toscanadb, $toscanadb);
$query_rs = "SELECT Objekt, gebietname, Wohnung, Personen, HS, NS, VS, ER, Kaution, Strom, Heizung, Tiere, Pool, Bettwäsche, Sonstiges, Ortsnamen, Filepfad FROM anwesen, gebiet, hauser, haeuserinanwesen, ort WHERE anwesen.g_id = gebiet.g_id AND gebiet.gebietname = '".$gebiet."' AND anwesen.a_id=haeuserinanwesen.a_id AND haeuserinanwesen.h_id=hauser.h_id AND ort.o_id = anwesen.o_id";
$rs = mysql_query($query_rs, $toscanadb) or die(mysql_error());
$row_rs = mysql_fetch_assoc($rs);
$totalRows_rs = mysql_num_rows($rs);
?><html>
<head>
<title><?php echo $row_Recordset1['titel']; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.Stil1 {color: #A4BC83}
.Stil4 {font-family: Verdana, Arial, Helvetica, sans-serif}
.Stil5 {font-size: 16px}
.Stil8 {
font-size: 14px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
color: #000000;
}
-->
</style>
</head>
<body>
<table cellpadding="0" cellspacing="0" align="center" border="0" bgcolor="#000000" width="800">
<tr>
<td width="1096"><table border="0" cellspacing="0" cellpadding="0" width="800">
<tr>
<td width="982" bgcolor="#F8C471"><table width="850" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="958" bgcolor="#F8C471"> <div align="center">Â*
<?include("modules/head.php");?>
</div></td></tr>
<tr>
<td bgcolor="#F8C471"></td>
</tr>
<tr>
<td bgcolor="#FFDB8F"><div align="center">
<?include("modules/top_leiste.php");?>
</div></td>
</tr>
<tr>
<td bgcolor="#F8C471"></td>
</tr>
</table>
<table width="766" height="84" cellpadding="0" cellspacing="0">
<tr>
<td width="168" height="38" valign="top" background="../img/tab_l1.jpg"><table width="200" border="0">
<tr>
<td><?include("modules/navigation/navigation.php");?></td>
</tr>
<tr>
<td></td>
</tr>
</table></td>
<td style="background-repeat: repeat-y; background-position:513px;
" width="792" valign="top"><table align="right" width="566">
<tr>
<td width="696" align="center" valign="top"><p align="left" class="Stil1">
<table width="640" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#F8C471">
<tr>
<td><table width="638" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td><span class="storytitle Stil4 Stil5"></span><span class="title Stil1 Stil4 Stil5"><span class="title Stil1 Stil4"></span></span>
<table width="434" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="328" height="19" bgcolor="#A4BC83"><span class="Stil8"><?php echo $gebiet;?></span></span></td>
<td width="106">[img]images/pixel0.gif[/img]</td>
</tr>
</table></td>
</tr>
</table> </td>
</tr>
</table>
<table width="637" border="0" align="center" cellpadding="0" cellspacing="0" style="border-collapse: collapse">
<tr>
<td width="100%"><div align="center">
<table width="635" border="0" align="center" cellpadding="0" cellspacing="0" id="AutoNumber5" style="border-collapse: collapse">
<tr bgcolor="#A4BC83">
<td width="129" align="center" style="color: #000000"> <font face="Tahoma" size="2">( Details - Click )</font></td>
<td width="90" align="left" style="color: #000000">
<p align="center"><font size="2" face="Tahoma"> Wohnung</font></td>
<td width="58" align="center" style="color: #000000">
<div align="center"><font face="Tahoma" size="2">Pers.</font></div></td>
<td width="61" align="center" style="color: #000000"> <font size="2" face="Tahoma"> Pool</font></td>
<td width="32" align="center" style="color: #000000"> <font size="2" face="Tahoma"> Tiere</font></td>
<td width="50" align="center" style="color: #000000"></td>
<td width="51" align="center" style="color: #000000"> <font face="Tahoma" size="2">HS €</font></td>
<td width="50" align="center" style="color: #000000"> <font face="Tahoma" size="2">NS €</font></td>
<td width="49" align="center" style="color: #000000"> <font face="Tahoma" size="2">VS €</font></td>
<td width="32" align="center" style="color: #000000"> <b class="boxcontent"><font face="Tahoma" size="2">ER €</font>[/b]</td>
</tr>
<?php
$gruppe="";
$span=0;
?>
<?php do {
if ($gruppe != $row_rs['Objekt']) {
if ($gruppe != "") {
echo "<tr height=15><td></td></tr>";
echo "<tr></tr>";
}
$gruppe=$row_rs['Objekt'];
$query_rs = "SELECT Wohnung FROM anwesen, gebiet, hauser, haeuserinanwesen, ort WHERE anwesen.g_id = gebiet.g_id AND gebiet.gebietname = '".$gebiet."' AND anwesen.a_id=haeuserinanwesen.a_id AND haeuserinanwesen.h_id=hauser.h_id AND ort.o_id = anwesen.o_id AND anwesen.Objekt = '".$gruppe."'";
$rs_anz = mysql_query($query_rs, $toscanadb) or die(mysql_error());
$span = mysql_num_rows($rs_anz)+1;
if ($span == 2) $span=3;
echo "<tr onClick=\"window.open('/detail.php?anwesen=".$gruppe."','','status=yes,scr ollbars=yes,width=666,height=615')\"><th width=\"50\" rowspan=".$span." valign=top bgcolor=\"#FFDB8F\" style=\"color: #000000\">
<img border=0 src=\"".$row_rs['Filepfad']."\">
</th><th colspan=9 align=left bgcolor=\"#FFDB8F\">".$gruppe." (".$row_rs['Ortsnamen'].")</th></tr>\n";
}
?>
<tr height=20>
<td width="129" align="left" bgcolor="#FFDB8F" style="color: #000000">
<p align="left" style="margin-left: 5; font-family: Tahoma; font-size: 12px; font-weight: bold;"> <span style=""><?php echo $row_rs['Wohnung']; ?></span></td>
<td width="90" align="center" bgcolor="#FFDB8F" style="color: #000000"><div align="center"><span class="boxcontent"><?php echo $row_rs['Personen']; ?> </span></div></td>
<td width="58" align="center" bgcolor="#FFDB8F" style="color: #000000"><span class="boxcontent"><?php echo $row_rs['Pool']; ?></span></td>
<td width="61" align="center" bgcolor="#FFDB8F" style="color: #000000"><div align="center"><span class="boxcontent"><?php echo $row_rs['Tiere']; ?></span></div></td>
<td width="32" align="center" bgcolor="#FFDB8F" style="color: #000000"></td>
<td width="50" align="center" bgcolor="#FFDB8F" style="color: #000000"><span class="boxcontent"><?php echo $row_rs['HS']; ?></span></td>
<td width="51" align="center" bgcolor="#FFDB8F" style="color: #000000"><span class="boxcontent"><?php echo $row_rs['NS']; ?></span></td>
<td width="50" align="center" bgcolor="#FFDB8F" style="color: #000000"><span class="boxcontent"><?php echo $row_rs['VS']; ?></span></td>
<td width="49" align="center" bgcolor="#FFDB8F" style="color: #000000"><span class="boxcontent"><?php echo $row_rs['ER']; ?></span></td>
</tr>
<?php } while ($row_rs = mysql_fetch_assoc($rs)); ?>
</table>
</div></td>
</tr>
</table>
</p>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#F8C471"></td>
</tr>
<tr>
<td bgcolor="#F8C471"><div align="center">
<table width="845" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#F8C471"></td>
</tr>
<tr>
<td bgcolor="#F8C471"><div align="center">
<?include("modules/copyright.php");?>
</div></td>
</tr>
<tr>
<td bgcolor="#F8C471"></td>
</tr>
</table>
</div></td>
</tr>
</table>
</body>
</html> |