use DBI; print "Content-type:text/html\n\n"; $dbh = DBI->connect("dbi:mysql:database=; host=; user=; password=") or die "Connecting to MySQL database failed: $DBI::errstr"; #Removed database,host,user and password details obviously $sSQL = "SELECT FirstName, LastName FROM Users"; $st = $dbh->prepare($sSQL) or die "Preparing MySQL query failed: $DBI::errstr "; $st->execute() or die "The execution of the MySQL query failed: $DBI::errstr"; while ($row = $st->fetchrow_hashref()) { print " $row->{FirstName} $row->{LastName}"; } $dbh ->disconnect();