Re: how do i construct a sql select statement, where i want to get the where clauses out of an array

One More Way To Do It:

use DBI;
my $dbh = DBI->connect("DBI:mysql:database=your_db");
my $where = "(id = '" . join ("' OR id = '", @ids) . "')";
my $sth = $dbh->prepare("SELECT * FROM event WHERE $where");
[download]

Then loop through the db output with

while ($ref = $sth->fetchrow_hashref) {
    &do_stuff_with($ref->{'db_col_u_like'});
}
[download]

NB when @ids is empty your SQL statement is SELECT * FROM event WHERE (id = '') which may be just what you want.

§ George Sherston

Comment on Re: how do i construct a sql select statement, where i want to get the where clauses out of an array Select or Download Code

Replies are listed 'Best First'.
Re: how do i construct a sql select statement, where i want to get the where clauses out of an array by pitbull3000 (Beadle) on Aug 25, 2001 at 21:30 UTC
bout the problem of an empty array i already thought, but the array shouldnt be empty it is filled with values out of a form, which invokes the script... but u never know... would it be some solution to put a zero as first id in the array, cause the zero wont be an id in the db table	[reply]
Re: Re: how do i construct a sql select statement, where i want to get the where clauses out of an array by George_Sherston (Vicar) on Aug 25, 2001 at 21:40 UTC
Yes, or just put the whole thing in an `if (@ids) { ... }`loop - which would make it work quicker when @ids was empty § George Sherston	[reply] [d/l]