What I've done before with mysql is do a 'DESCRIBE TABLE joemama' query and assign the
results to a hash withh the keys being a number starting with 0
0 => ID,
1 => name,
2 => etc,
Then I do my select and just do
@row = fetch_rowarray....
print "%column_name{$num} is $row[$num] \n";
Or create the table with column names as it's own TR.
Dan
>
>
>
> Hi
>
> I am working on a perl script that runs a sql which extracts
> all data from a view and prints them on a web page.
>
> But the problem is I am not able to print the field names as
> headings of the respective columns.
>
> Does anyone have any idea?
>
> Thanks
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, and more
>
