Thread MySQL Abfrage (26 answers)
Opened by Tom at 2004-03-26 17:13

renee
 2004-03-29 20:15
#31921 #31921
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Automatisiert würde das dann ungefähr so aussehen:
Code: (dl )
1
2
3
4
5
6
7
8
9
10
my @searchs = qw(Tom Test);
my @veranstalter = map{'veranstalter LIKE '.$_}@searchs;
my @beschreibung = map{'beschreibung LIKE '.$_}@searchs;
my $statement = 'SELECT * FROM event_topic WHERE ('.join(' OR ',@veranstalter).') AND ('.join(' OR ',@beschreibung).') ORDER BY time;';
my $sth = $dbh->prepare($statement);
$sth->execute();
while(my @array = $sth->fetchrow_array()){
 print "@array";
}
$sth->finish();
\n\n

<!--EDIT|renee|1080577007-->
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/

View full thread MySQL Abfrage