Changeset 135


Ignore:
Timestamp:
12/02/11 15:15:59 (9 years ago)
Author:
astrid.emde
Message:

Umstellung auf Suche in der Art:

Nachname
Nachname, Vorname
Nachna*
Doppel-Name, Vor*
Nachname, Zwei Vornamen
Nachname, Doppel-Vorname

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/data/mapbender/http/nav/alkisnav_eig.php

    r134 r135  
    4141        global $gkz, $gemeinde, $epsg, $con, $name, $person, $gb; 
    4242        $linelimit=120; 
    43         $arr = explode(" ", $name); 
     43        $arr = explode(",", $name); 
    4444        $name0 = trim($arr[0]); 
    4545        $name1 = trim($arr[1]); 
     
    5454        } else { 
    5555                $match1 = trim($name1)."%"; 
    56         }        
     56        }                
     57         
    5758        $sql ="SELECT p.nachnameoderfirma, p.vorname, p.gml_id FROM ax_person as p "; 
    5859        if($match1 != '%'){ 
    59                 $sql.="WHERE p.vorname ILIKE $1 AND nachnameoderfirma ILIKE $2 ";                
     60                $sql.="WHERE nachnameoderfirma ILIKE $1 AND p.vorname ILIKE $2 ";                
    6061                $sql.="ORDER BY p.nachnameoderfirma, p.vorname LIMIT $3 ;"; 
    6162                $v=array($match, $match1, $linelimit); 
Note: See TracChangeset for help on using the changeset viewer.