|
Registriert seit: 26. Mai 2004
3.159 Beiträge
|
AW: Fehlerhafte Abfrage
6. Jul 2011, 20:23
SQL-Code:
SELECT
a.*,
k.name as k_name,
k.vorname as k_vorname
from
adressen a
LEFT OUTER JOIN adr_kategorien k on k.id = a.kategorie_id
WHERE
(a.name LIKE :such1) OR (a.vorname LIKE :such2)
ORDER BY
k.id, a.name, a.vorname
LIMIT
0,15;
Danke 
»Remember, the future maintainer is the person you should be writing code for, not the compiler.« (Nick Hodges)
|