Code:
$sth = $dbh->prepare("SELECT name FROM items WHERE id = $looted_id");
$sth->execute();
my $row = $sth->fetchrow_array();
I was using this in an EVENT_LOOT -- just for testing how to use DBI.
But this would fetch the item name of whatever you looted.. was mainly just for testing purposes..
Just change it a bit and I'm sure you could easily fetch something from one of your custom tables!
If you need help with something specific I don't mind shooting you some help.