new to perl, very simple question fetchrow 1

[AlbertAguirre]

I am selecting 2 columns in my SQL. I only know how to use fetchrow.
How do i tell perl to get the second table column specified in my sql?

Heres my code:

$p_detSql=$dbh1->prepare ("SELECT firstname, lastname FROM tNetworkDet");
$p_detSql->execute();
$lastname=$p_detSql->fetchrow(); <-- doesnt work

How do I get lastname?

 

[audiopro]

Assign fetchrow to an array rather than a scaler, then the results are elements of the array.
Here is an example from one of my progs.

my $sql="SELECT EMAIL,U,P FROM ARTISTS WHERE EMAIL='$SENDML' AND BIRTH='$BTOWN'";
my $sth=$dbh->prepare($sql);
$sth->execute();
@results=$sth->fetchrow_array();
print "$results[0] - $results[1] - $results[2]<br>";

Keith

http://www.studiosoft.co.uk