Perl/MySQL/Arrays

[wombat]

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?

[Haitek]

Re: Perl/MySQL/Arrays

my $sql = "SELECT * FROM addresses";
my $sth = $dbh->prepare($sql );
$sth->execute();
while(my $row = $sth->fetchrow_hashr ef()) {
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?

[Haitek]

Re: Perl/MySQL/Arrays

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_hashr ef()) {
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?

[wombat]

Re: Perl/MySQL/Arrays

In article <dGkZh.3615$iR2 .184@trnddc05>, Haitek <hitech69@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_hashr ef()) {
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).