As Brian said, there are many ways to do it - you need to RTFM
to figure out which way best suits your need.
perldoc DBI
the perldocs are your friend :-)
HTH.
--
Hardy Merrill
Senior Software Engineer
Red Hat, Inc.
Brian McCain [[EMAIL PROTECTED]] wrote:
> 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
> >
