Hey,
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:
(Note: MySQL database)
my $tablename = "tablename"; #get around taint warning
$sql = "LISTFIELDS $tablename";
$sth = $dbh->prepare($sql);
$sth->execute;
@generic = @{$sth->{NAME}};
@perm = @generic;
$sth->finish;
$sql = "Select * from tablename where idnr='$somenumber'";
$sth = $dbh->prepare($sql);
$sth->execute;
@generic = $sth->fetchrow;
@results = @generic;
$sth->finish;
$count = @perm;
$i = 0;
do {
print "$i - $perm[0] is $results[0]<br>";
$i++;
} until ($i >= $count);
Ignore the last part, it's just an example of what I'm trying to do with the
results. I know it's nasty, I do better code than that. ;-)
This works, but I'm not sure how well to trust it with it being two separate
statements.
Is there a better way? I've been working with DBI for quite a while, but
haven't had to deal with column names until now.
Thanks,
Joe
--
Now Playing: Joan Jett - Everyday People
[From Album (1983)] (1:07/2:41)
Powered by XMMS and SuSE Linux 8.2 Pro
