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