Help with displaying columns/fields of a table, please

[kknorpp001]

Hello.

I am attempting to display the contents of a table and, naturally, would like to include the column/field NAMES at the top of the output. The following code with print out the 1st column name, so I am getting close, and have tried several ways to get it to print the remaining columns, but no luck. Help, please. Many thanks in advance....


$columns = odbc_columns ($connection, "PC.mdb", "", "results"

$item = odbc_result($columns, 4);

print "$item";

 

[devwilcat]

Why not try the odbc_fetch_into() function.

Keep your first line as is but then do:

$rowcount = odbc_fetch_into($columns, $namearray);
if ($rowcount != FALSE)
{
foreach ($rowcount as $elem)
print $elem;
}
else
print "Could not fetch rows...";

Hope this helps

Devon

 

[kknorpp001]

Thanks. That allows me to see the array, which is posted below. But, instead of returning the column names, it is returning the details of the first column only. How do I get the other columns? Thanks again for your help..

D:\HTML\USERS\DOMAINCOM\database\PC

results
RiderNum
4
INTEGER
10
4
0
10
1


4


1
YES
1

 

[devwilcat]

It seems as though ODBC_fetch_into only grabs the array for one column. Try putting the ODBC_fetch_into statement into a while loop. This way it will keep fetching until there are no more columns to fetch. If you're only interested in the column name, put the column names into their own array:

while (ODBC_fetch_into($columns, $rowarray)
array_push($colarray, $rowarray[COLUMN_NAME]);

foreach ($colarray as $var)
print &quot;$var <BR>&quot;;

Cheers,
Devon

 

[kknorpp001]

Thanks for your help. FYI - Found the answer here:

http://www.php-forums.com/forums/showthread.php?s=&threadid=56