Errors fetching rows and results

mklangem

I am trying to get the table names from an Access database using odbc_tables() and then using odbc_fetch_row() and odbc_result(). I can print all the results using odbc_result_all() which gives an html table with all the information (In my test database I get 8 rows). However when I try to go through the results using fetch_row() and odbc_result() I get cgi errors. I want to do something like this:

<?
$array = odbc_tables($conn);
$names = array()
while(odbc_fetch_row($array)) {
$type = odbc_fetch_row($array, "TABLE_TYPE");
if($type == "TABLE") {
$names[] = odbc_fetch_row($array, "TABLE_NAME");
}
}
?>

I've tried going through step by step and weird things are happening. This works:

<?
$array = odbc_tables($conn);
$names = array();
$i = 0;
odbc_fetch_row($array);
echo $i." ";
$i = odbc_fetch_row($array);
echo $i." ";
$temp = odbc_result($array, "TABLE_NAME");
echo $temp;
?>

But this doesn't:

<?
$array = odbc_tables($conn);
$names = array();
$i = 0;
// add extra assign of $i to odbc_fetch
$i = odbc_fetch_row($array);
echo $i." ";
$i = odbc_fetch_row($array);
echo $i." ";
$temp = odbc_result($array, "TABLE_NAME");
echo $temp;
?>

It seems like I can only assign or check odbc_fetch_result() and odbc_results() a total of two times. If I don't check or assing anything, I can get to the eigth row. If I do check or assign more than 2 twice, I get a cgi error. It seems very weird. Has anyone had similar problems? Or are there suggestions for a better way of getting the information I need.

Thanks,
Matt

tmarlow

Hey,
I too got the same kind of error, although my browser would just sit there and keep trying to load rather than get an outright CGI error. I've managed to more or less jury rig a solution that will pull table names out of the Access Database, and you can add and delete table names from the database and the script should still run ok. Once again, the key here is that you can access odbc_fetch_row as many times as you'd like, you just can't access odbc_result more than twice per database connection. The code:

//Initialize Variables
$counter = 1;
$last_result = "";

while (True) {

//Make sure you change the "C:\Database\web_database" for your own //'TABLE_CAT'
$array = odbc_tables($connection, "C:\Database\web_database", "", "%", "'TABLE'");

//Increment the row pointer through the rows
for($i=0; $i<$counter; $i++){
odbc_fetch_row($array);
}

$result = odbc_result($array, "TABLE_NAME");

//The trick for breaking this loop, when odbc_fetch_row gets to the last record //and is called again, it just fetches the last record again. So if the current table //and the previously accessed table are the same, break the loop, you've got //them all.

if ($last_result == $result) {
break;

} else {
$last_result = $result;

}

echo $result . " ";
$array = NULL;
odbc_close($connection);
include('login.inc'); //The odbc_connect function
$counter = $counter + 1;
}