😃 try & catch kenn ich bisher nur aus JAVA :-P naja... 😃
Der CODE vom PHP sieht momentan noch so aus:
<?php
$host = "localhost";
$user = "****";
$pass = "****";
$db = "****";
$connect=mysql_connect($host,$user,$pass);
mysql_select_db($db,$connect);
$res = mysql_query("SELECT * FROM kundenverwaltung");
$num = mysql_num_rows($res);
echo "
<form method="post" action="$PHP_SELF">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td><table cellpadding="0" cellspacing="0" border="0">
";
for ($i=0; $i<$num; $i++)
{
$k_fn = mysql_result($res, $i, "Firmenname");
$k_ap = mysql_result($res, $i, "Ansprpartner");
$k_ort = mysql_result($res, $i, "Ort");
$k_str = mysql_result($res, $i, "Str");
$k_hnr = mysql_result($res, $i, "Hnr");
$k_plz = mysql_result($res, $i, "Plz");
$k_tel = mysql_result($res, $i, "Tel");
$k_fax = mysql_result($res, $i, "Fax");
$k_em = mysql_result($res, $i, "Email");
$k_ws = mysql_result($res, $i, "Website");
$k_br = mysql_result($res, $i, "Branche");
echo "
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td height="20" colspan="2" class="h1"><b>$k_fn</b> (<a href='http://$k_ws' target="_blank">$k_ws</a>)</td>
</tr>
<tr>
<td colspan="2"><b>Branche:</b> $k_br<br><b>Ansprechpartner:</b> $k_ap</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td class="left">$k_plz $k_ort<br>$k_str $k_hnr</td>
<td class="right">Telefon: $k_tel<br>Fax: $k_fax<br>E-Mail: $k_em</td>
</tr>
<tr>
<td class="spacer" colspan="2"> </td>
</tr>
";
}
echo "
</table>
</td>
<td width="20">
</td>
<td valign="top">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="10" class="h1"><b>Suche</b></td>
</tr>
<tr>
<td><select name="spalte">
<option>Firmenname</option>
<option>Ort</option>
<option>Plz</option>
</select> <input type="Text" name="allg_suche"> <input type="submit" name="a_suche" value="Suche">
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>Suche nach dem Begriff: "<b>$allg_suche</b>" in der Rubrik: "<b>$spalte</b>"</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
";
if ($a_suche && $allg_suche!=""){
$res2 = mysql_query("SELECT * FROM kundenverwaltung where $spalte = '$allg_suche'");
$num2 = mysql_num_rows($res2);
for ($i=0; $i<$num2; $i++)
{
$k_fn = mysql_result($res2, $i, "Firmenname");
$k_ap = mysql_result($res2, $i, "Ansprpartner");
$k_ort = mysql_result($res2, $i, "Ort");
$k_str = mysql_result($res2, $i, "Str");
$k_hnr = mysql_result($res2, $i, "Hnr");
$k_plz = mysql_result($res2, $i, "Plz");
$k_tel = mysql_result($res2, $i, "Tel");
$k_fax = mysql_result($res2, $i, "Fax");
$k_em = mysql_result($res2, $i, "Email");
$k_ws = mysql_result($res2, $i, "Website");
$k_br = mysql_result($res2, $i, "Branche");
echo "
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="20" colspan="2" class="h1"><b>$k_fn</b> (<a href='http://$k_ws' target="_blank">$k_ws</a>)</td>
</tr>
<tr>
<td colspan="2"><b>Branche:</b> $k_br<br><b>Ansprechpartner:</b> $k_ap</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td class="left">$k_plz $k_ort<br>$k_str $k_hnr</td>
<td class="right">Telefon: $k_tel<br>Fax: $k_fax<br>E-Mail: $k_em</td>
</tr>
<tr>
<td class="spacer" colspan="2"> </td>
</tr>
</table>
";
}}
else {
echo "<tr>
<td><b>Bitte geben Sie einen Suchbegriff ein</b></td>
</tr>";
}
echo "
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
";
?>