By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,865 Members | 1,453 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,865 IT Pros & Developers. It's quick & easy.

Perl/MySQL/Arrays

P: n/a
I have a question about using arrays in Perl, involving connecting to
MySQL databases.

In the past I've used PHP to access databases and I've been playing
around now with Perl. In PHP to access data in an array you would see
something along the lines of $theresult['firstname'] and this would
retrieve the data under the column "firstname". So far the only way I
see how to retrieve data from an array in Perl would be $theresult['1'],
insert whatever number you want.. hopefully it would be the column for
"firstname". Is there any way around this problem?
Apr 30 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
my $sql = "SELECT * FROM addresses";
my $sth = $dbh->prepare($sql);
$sth->execute();
while(my $row = $sth->fetchrow_hashref()) {
print "$row->firstname $row->lastname\n";
}
$sth->finish();
wombat wrote:
I have a question about using arrays in Perl, involving connecting to
MySQL databases.

In the past I've used PHP to access databases and I've been playing
around now with Perl. In PHP to access data in an array you would see
something along the lines of $theresult['firstname'] and this would
retrieve the data under the column "firstname". So far the only way I
see how to retrieve data from an array in Perl would be $theresult['1'],
insert whatever number you want.. hopefully it would be the column for
"firstname". Is there any way around this problem?
Apr 30 '07 #2

P: n/a
Boy, I think I messed that up by combining PHP with Perl. :-)

$row->{firstname} $row->{lastname} or $row->{'firstname'} $row->{'lastname'}

lol, I need a break!

Haitek wrote:
my $sql = "SELECT * FROM addresses";
my $sth = $dbh->prepare($sql);
$sth->execute();
while(my $row = $sth->fetchrow_hashref()) {
print "$row->firstname $row->lastname\n";
}
$sth->finish();
wombat wrote:
>I have a question about using arrays in Perl, involving connecting to
MySQL databases.

In the past I've used PHP to access databases and I've been playing
around now with Perl. In PHP to access data in an array you would see
something along the lines of $theresult['firstname'] and this would
retrieve the data under the column "firstname". So far the only way I
see how to retrieve data from an array in Perl would be
$theresult['1'], insert whatever number you want.. hopefully it would
be the column for "firstname". Is there any way around this problem?
Apr 30 '07 #3

P: n/a
In article <dGkZh.3615$iR2.184@trnddc05>, Haitek <hi******@yahoo.com>
wrote:
Boy, I think I messed that up by combining PHP with Perl. :-)

$row->{firstname} $row->{lastname} or $row->{'firstname'} $row->{'lastname'}

lol, I need a break!

Haitek wrote:
my $sql = "SELECT * FROM addresses";
my $sth = $dbh->prepare($sql);
$sth->execute();
while(my $row = $sth->fetchrow_hashref()) {
print "$row->firstname $row->lastname\n";
}
$sth->finish();
wombat wrote:
I have a question about using arrays in Perl, involving connecting to
MySQL databases.

In the past I've used PHP to access databases and I've been playing
around now with Perl. In PHP to access data in an array you would see
something along the lines of $theresult['firstname'] and this would
retrieve the data under the column "firstname". So far the only way I
see how to retrieve data from an array in Perl would be
$theresult['1'], insert whatever number you want.. hopefully it would
be the column for "firstname". Is there any way around this problem?
Heh, I actually got locked into trying to figure it out myself and ended
up finding the answer at like 3 in the morning.. YAWN. But thanks. I'm
currently trying to figure out how to count words in a string (or an
array).
May 1 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.