View Single Post

  #1 (permalink)  
Old 04-18-2008
Deepan MYSQL
 
Posts: n/a
Default Table Information

Hi All,
I want to get the information about a table i mean getting
the column name and type. I am using the below code:

my $possible_inquiryTypes = $dbh->prepare_cached('DESC
ticket_inquiry_type');
$possible_inquiryTypes->execute();
while( my $option = $possible_inquiryTypes->fetchrow() ) {
print $option;
}


It is not printing anything. But when i used the below code

my $count = $possible_inquiryTypes->execute();
print $count;
---------------------------------------------------------------> it
printed 2


Does anyone know the problem in this?

Reply With Quote