getMessage() ); } print ''; $apu = "%" . $_REQUEST["haku"] . "%"; $kayttaja = $dbh->prepare("SELECT UserId, UserName, DomainName FROM User, Domain WHERE User.UserName || '@' || Domain.DomainName LIKE :haku AND User.Domain_DomainID = Domain.DomainID "); if ( !$kayttaja ) { // print_r( $dbh->errorInfo() ); print("Tietokantavirhe"); } $kayttaja->bindParam(":haku", $apu); $ok = $kayttaja->execute(); if ( !$ok ) { // print_r( $kuviot->errorInfo() ); print("Tietokantavirhe"); } while ($rivi = $kayttaja->fetch(PDO::FETCH_ASSOC)) { print '' . $rivi["UserName"] . "@" . $rivi["DomainName"] . ""; } print ""; ?>