my $sth= $dbh->prepare( 'SELECT * FROM user_items WHERE indexnum = ?');
$sth->execute($value);
while(my (undef, $val1, $val2, $val3) = $sth->fetchrow_array) {
 print "$val1, $val2, $val3\n";
}