Re: retrieving a value from mysql and use it later

On Apr 10, 2005, at 11:30 AM, Eko Budiharto wrote: Hi, I would like to ask about how to retrieve a value from mysql and use it later. What I mean is like this This is really a perl question, not mysql. my is a scoping operator. Variables declared with my disappear when they go out of scope. my

retrieving a value from mysql and use it later

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;