43 lines
1.6 KiB
PHP
43 lines
1.6 KiB
PHP
<?php
|
|
$sql = "SELECT * FROM Uns WHERE ID='1';";
|
|
$result = $db->query($sql);
|
|
$nt = $result->fetch_assoc();
|
|
$sql1 = "SELECT * FROM Firma WHERE ID='2' ";
|
|
$result1 = $db->query($sql1);
|
|
$nt1 = $result1->fetch_assoc();
|
|
|
|
$titel = explode ( '||', $nt['Titel'] );
|
|
$texte = explode ( '||', $nt['Text'] );
|
|
?>
|
|
<table>
|
|
<colgroup>
|
|
<col span="3" width="250px"/>
|
|
</colgroup>
|
|
<tr>
|
|
<th><big><?php echo $titel[0]; ?></big></th>
|
|
<th><big><?php echo $titel[1]; ?></big></th>
|
|
<th><big><?php echo $titel[2]; ?></big></th>
|
|
</tr>
|
|
<tr>
|
|
<td rowspan="2" style="vertical-align:top;text-align:justify;padding-right:25px;"><?php echo nl2br ( $texte[0] ); ?></td>
|
|
<td style="vertical-align:top;text-align:justify;padding-right:25px;"><?php echo nl2br ( $texte[1] ); ?></td>
|
|
<td rowspan="2" style="vertical-align:top;text-align:justify;"><?php echo nl2br ( $texte[2] ); ?></td>
|
|
</tr>
|
|
<tr valign="top">
|
|
<td valign="top" style="vertical-align:top;text-align:center;">
|
|
<b><?php echo $nt1['Firma']; ?></b><br />
|
|
<?php echo $nt1['Strasse']; ?> <?php echo $nt1['HausNr']; ?><br />
|
|
<?php echo $nt1['PLZ']; ?> <?php echo $nt1['Ort']; ?><br />
|
|
<br />
|
|
Telefon: <?php echo $nt1['Telefon']; ?><br />
|
|
Telefax: <?php echo $nt1['Telefax']; ?><br />
|
|
<a href="mailto:<?php echo $nt1['EMail']; ?>"><?php echo $nt1['EMail']; ?></a><br />
|
|
<a href="index.php?section=home">www.twe-immobilien.de</a>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<br /> <br />
|
|
<p style="text-align: center;">
|
|
<img style="float: none;" src="img/team/uu_oben.png" title="TWE-Immobilien" alt="TWE-Immobilien" />
|
|
</p>
|