Try this (I use mysql - thus your mileage can vary): $column_list = $connect->prepare("LISTFIELDS $oppanel_table") ; $column_list->execute() ; $column_list_numrows = $column_list->{NUM_OF_FIELDS} ;
for ($x=0;$x < $column_list_numrows; $x++) { print "$column_list->{NAME}->[$x]" ; } Took me forever to figure this out lol V. ---------------------------------------------------------------------------------------- This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ---------------------------------------------------------------------------------------- Anthony Nickolayev To: [EMAIL PROTECTED] <dodger cc: @rwl.buryatia.ru Subject: How can I fetch column names? > 06/10/2003 04:33 AM Greetings. Maybe the answer for my question will be RTFM, but i still cant find it myself. The problem is: i need to fetch just list, contains column names - and i dont know how to do it. I didnt find it in DBI manual page, and anywhere else. Thanks anyway, and sorry for my english.