Naja, was soll ich schreiben...Ich will aus einer MySQL-Datenbank mittels PHP Daten rauspressen, genauer gesagt, ich suche eine Postleitzahl, und PHP soll mir dann ausspucken, wer dafür in Frage käme, wenn ich PLZ 54321 eingebe...
Aktueller Stand:
mysql_connect($hostname, $selectuser, $selectpwd);
if ($Class>0) {
$classreq="AND classkey=$Class";
}
if (!$Order) {
$Order="Name";
}
if ($id)
$query = "SELECT * FROM haendler LEFT JOIN classes ON class=classkey WHERE pid=$id";
else
$query = "SELECT * FROM haendler LEFT JOIN classes ON class=classkey where Vorname LIKE '%$Vorname%' AND Name LIKE '%$Name%' AND PLZ LIKE '%$PLZ%' AND Ort LIKE '%$Ort%' AND mail LIKE '%$mail%' AND web LIKE '%$web%' AND Firma1 LIKE '%$Firma1%' AND Firma2 LIKE '%$Firma2%' AND Land LIKE '%$Land%' $classreq ORDER BY $Order";
$result = mysql_db_query($dbName,$query);
echo "<center>";
if ($result){
if ($r = mysql_fetch_array($result)){
do {
$ri = $r[rights];
if ($ri==2 && $AUTHUSER!=$r[owner])
continue;
echo "<table cellpadding=0 cellspacing=2 width=350>
<tr bgcolor=$colorvalues><td><font size='2' face='verdana, Arial'> $r[Vorname] $r[Name]</font></td></tr>
<tr bgcolor=$colorframes><td><font size='2' face='verdana, Arial'>$r[Firma1]</font></td></tr>
<tr bgcolor=$colorvalues><td><font size='2' face='verdana, Arial'>$r[Firma2]</font></td></tr>
<tr bgcolor=$colorframes><td><font size='2' face='verdana, Arial'>$r[Strasse]</font></td></tr>
<tr bgcolor=$colorvalues><td><font size='2' face='verdana, Arial'>$r[PLZ] $r[Ort]</font></td></tr>
<tr bgcolor=$colorframes><td><font size='2' face='verdana, Arial'>$r[Tel]</font></td></tr>
<tr bgcolor=$colorvalues><td><font size='2' face='verdana, Arial'><a href=\"mailto:$r[mail]\">$r[mail]</a></font></td></tr>
<tr bgcolor=$colorframes><td><a href=\"$r[url]\">$r[url]</a></font></td></tr>
</table><hr>";
} while ($r = mysql_fetch_array($result));
} else {
echo "<b>$l[search_failed]</b><br>
So long...
Datum: 29.11.2005-17:03
SQL-Abfrage bringt zuuuuu viele Ergebnisse . . .
