On Tue, 23 Sep 2003 09:37:42 +1000, Fox, Michael wrote:
>If you are not worried about the order in which the columns come back, you
>could select straight into a hash and save a few lines of code
Or blend the two aproaches, use $sth->{NAME} to get an array of names in
the proper order, and use a
If you are not worried about the order in which the columns come back, you
could select straight into a hash and save a few lines of code - something
like this:
my $r_results=$dbh->selectrow_hashref("Select * from $tablename where
idnr=?",{},($somenumber));
foreach my $col_name (keys %$r_result
On Mon, 22 Sep 2003 07:23:17 +0200 JoeJoeJoeJoe <[EMAIL PROTECTED]> wrote:
> Basically trying to get 1 set of results returned, along with all
> column names at the same time.
>
> Is there an easier way to do it than this? Here's what I have:
There is, see below.
> (Note: MySQL database)
>
> m