Hi, I would like to ask about how to retrieve a value from mysql and use it later. What I mean is like this my $ref = $sth->fetchall_arrayref(); foreach my $row (@$ref) { my ( $passengerIndex, $passengerName, $passengerEmailAddress, $passengerLoginPassword ) = @$row; my $new = $passengerIndex; } ...<other scripts and html header> print $new; but it does not work. so far, when I want to use it, I always do this my $ref = $sth->fetchall_arrayref(); foreach my $row (@$ref) { my ( $passengerIndex, $passengerName, $passengerEmailAddress, $passengerLoginPassword ) = @$row; my $new = $passengerIndex; ...<other scripts and html header> print $new;
} __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com