szabgab/perl5maven.com — pull request #185 by newbcode (2013-06-16 15:26:22+00:00)
Title: example code(simple-database-access-using-perl-dbi-and-sql) modify

Hello my name is Yunchang Kang.
I am seoul.pm member.
I like perl5maven and usually like a lot of help.

I have translated the perl5maven.
Two pages translating :) .
Translation will be completed soon.

This is commit "SELECT" session of example (simple-database-access-using-perl-dbi-and-sql ) code.
=========================================================
my $sql = 'SELECT fname, lname FROM people WHERE id > ? AND id < ?';
my $sth = $dbh->prepare($sql);
$sth->execute(1, 10);
while (my @row = $sth->fetchrow_array) {
print "fname: $row[0] lname: $row[1]\n";
}
=========================================================
I think so ...from a reader's point of view
'SELECT fname, lname FROM people WHERE id > ? AND id < ?' if conditions did not ourput so newb is hard to understand.
Because nothing is output to the console.
And i think so.........should be replaced by 'SELECT fname, lname FROM people WHERE id > ? AND id < ?' condition on 'SELECT fname, lname FROM people WHERE id >= ? AND id < ?'

Another way to insert data to two or more ways.

Thanks.

See you Again.