For single values I usually use this DBI function and query: my $val =3D $dbh->selectrow_array("SELECT value FROM tab1 WHERE test=3D= 2"); However, what if I want to store a bunch of values into an array? my @vals =3D $dbh->?????("SELECT value FROM tab1 WHERE test > 10"); What's the syntax I'm missing above? Any help appreciated! [.kate] ___________________________________________________________________________ Visit http://www.visto.com. Find out how companies are linking mobile users to the enterprise with Visto. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php