On Wed, 12 Sep 2001 13:50:39 +0900, Karina Nahagama wrote:
>while (my $record = $state->fetchrow_arrayref){
> print '<BR> User ID : ', $record->[0]; #[USER_ID]
> print ' PASSWORD : ', $record->[1]; #[PASSWORD]
> }
>
> In this case I have to pick-up the field information with the field number
>$record->[0].
> I want to pick-up the selected information by calling the fields by their
>names.
> How can I pick-up the field information with the field name ? (for example
>USER_ID)
By using fetchrow_hashref instead of fetchrow_arrayref. $record will
then be a hashref.
--
Bart.
