<?php
defined (
'main'
)
or
die
(
'no direct access'
);
$abf
=
'SELECT * FROM prefix_kunden'
;
$erg
= db_query(
$abf
);
echo
'
<table border=
"0"
width=
"779"
height=
"62"
cellpadding=
"0"
>
<b><font size=
"4"
align=
"center"
>Lieferanten Adressen
</font></b>
<p><b>
<form action=
"<?php echo $_SERVER['PHP_SELF']; ?>"
method=
"post"
>
<p>Geben Sie einen Suchbegriff ein:
<input type=
"text"
name=
"SuchNach"
>
<input type=
"button"
value=
"suchen"
onclick=
"find(this.form.SuchNach.value, false, false)"
>
</form>
Drucken:
<a href=
"javascript:window.print()"
>
<tr>
<td height=
"25"
width=
"155"
align=
"center"
bgcolor=
"#333333"
>
<font color=
"#FFFFFF"
>Firma / Name</font></td>
<td height=
"25"
width=
"156"
align=
"center"
bgcolor=
"#333333"
>
<font color=
"#FFFFFF"
> Email</font></td>
<td height=
"25"
width=
"156"
align=
"center"
bgcolor=
"#333333"
>
<font color=
"#FFFFFF"
>Telefon</font></td>
<td height=
"25"
width=
"156"
align=
"center"
bgcolor=
"#333333"
>
<font color=
"#FFFFFF"
>Kundennummer</font></td>
<td height=
"25"
width=
"156"
align=
"center"
bgcolor=
"#333333"
>
<font color=
"#FFFFFF"
>Mehr</font></td>
</tr>';
while
(
$row
= db_fetch_object(
$erg
))
{
echo
'<tr>
<td height=
"37"
width=
"155"
align=
"center"
bgcolor=
"#B2B2B2"
>
'.$row->firma.'
'.$row->vorname.'
'.$row->name.'
</td>
<td height=
"37"
width=
"156"
align=
"center"
bgcolor=
"#CDCDCD"
>
'.$row->email.'
</td>
<td height=
"37"
width=
"156"
align=
"center"
bgcolor=
"#B2B2B2"
>
'.$row->telefon.'
</td>
<td height=
"37"
width=
"156"
align=
"center"
bgcolor=
"#CDCDCD"
>
'.$row->fnr.'
</td>
<td height=
"37"
width=
"156"
align=
"center"
bgcolor=
"#B2B2B2"
><div align=
"center"
><a href=
"/?detailss-'.$row->id.'"
>Mehr</a></td>
</tr>';
}
echo
'</table>'
;?>