Hi All, I have created a simple sql script to write an email address (from form input) to a MySQL database, the database itself is very simple, and only stores just email addresses. Below is my code to read the data, line by line, but this script is expected to store upto 20,000 email addresses (will this cause problems?) so printing them line by line will take a while to load and create an extremely large page, could anyone advise me as to how I could read the data and split it in different pages, say 30 emails per page ?

$dbh = DBI->connect("DBI:mysql:$database:localhost","$username","$pass
+word");

my $sth = $dbh->prepare("SELECT * FROM emails");
$sth->execute(); # iterate through resultset 
while(my $ref = $sth->fetchrow_hashref()) { 
print "Email: $ref->{'contest'}\n\n";
 } # clean up
 $dbh->disconnect();
[download]

Thats how I do it at the moment, but splitting it into pages of 30 emails would make it a lot more organised.
Any help would be great appreciated

Thanks,
John.

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.