i tried that bt the problem i get repeated output like

FOO FOO
BAR BAR 
MOO MOO
[download]

i changed my code from

my $select = $DBH->prepare("SELECT FOO, BAR, MOO FROM tble WHERE CONCA
+T(FOO, ', ', BAR, ', ', MOO) LIKE ?");
$select->execute('%'.$info.'%');
$names = $select->fetchall_arrayref();
    foreach $names ( @$names) {
        ($variable1, $variable2, $variable3) = @$names;
}
}
[download]

to this

my $select = $DBH->prepare("SELECT FOO, BAR, MOO FROM tble WHERE CONCA
+T(FOO, ', ', BAR, ', ', MOO) LIKE ?");
$select->execute('%'.$info.'%');
$names = $select->fetchrow_arrayref();
    
        ($variable1, $variable2, $variable3) = @$names;
}
[download]

I don't see $variable1, $variable2, $variable3 used anywhere in your code posted here, what are they for ? And what is the value of $info ?

poj

but its there wen u look at the code and $info is just user input to confirm weather there is an input from user to execute the condition

but anyway am trying it differently coz it has given alot problem to me and monks to figure it out. just gone try other method to accomplish wat i want