#!/usr/bin/perl -w use strict; use DBI; use Data::Dumper; $|++; my $dbh = DBI->connect("dbi:mysql:wordpress","username","password"); my $sth = $dbh->prepare('SELECT ID, placeName FROM wp_ajax_places WHERE ID <= 5'); $sth->execute; my $h = $sth->fetchall_hashref([ 1..2 ]); print Dumper(\$h);