in reply to Getting MySQL Data into an Array.

cdherold - execute () passes data that you want in any placeholders, e.g.:

$sth = $dbh->prepare ('SELECT * FROM users WHERE id = ?'); $sth->execute ($my_id);

What you're looking for is $sth->fetchrow_array (), or some other variant. You can also use the 'latest' additions to DBI to grab the lot, with a $sth->fetchall_arrayref ()