Assuming you've got the columns "customer_id" and "username" in your
database, you could do something like:
my $row = $sth->fetchrow_hashref;
my $cust_id = $row->{customer_id};
my $username = $row->{username};
Though, as usual, there are a whole bunch of different ways of doing it,
depending on the specifics of what you're trying to do.
-----------------
Brian McCain
PageMasters Internet Group
> Greets,
>
> This question will be generally spoken, but I think it
> makes enough sense to be answered.
>
> Suppose I run some sort of query that pulls in a row
> of information, and that row contains four columns of
> information, like custmer_id, username, passwrd and
> secret message. Usually, it seems this info is read
> into an array by using fetchrow_array(),
> fetchrows_arrayref() or fetchrow_hashref(), but what I
> dont get is how I could "break up" the array into
> specific variables.
>
> Usually, I just use the CGI.pm param("blah") method to
> reference input values, but I dont get how I would do
> that using the DBI functions, especially in the
> context of loops.
>
> I hope this makes some sense, but let me know
> otherwise. Even criticisms of questions can help
> sometimes.
>
> Thanks,
>
> Will
>
>
> __________________________________________________
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
>
