Hello PHP community,
I have code that implements crosstabulation of two questions for an online survey tool.
It works perfectly in IE and netscape 4x, but it flails in netscape 6.2.
Any help would be appreciated!
We are at this point using MS Access to develop the tool
(until MySQL supports nested queries)
Here is an example of dummied up code, which is inside a function call:
$answer_sql = "SELECT answerContent, answerID";
$answer_sql .= " FROM TBL_POSSIBLEANSWER";
$answer_sql .= " WHERE answerID LIKE '" . $crosstab[$qID1index] . "n%'";
$answer_result = odbc_prepare($connection,$answer_sql);
odbc_execute($answer_result);
echo”all browsers get to here fine!!(display message on screen)”;
while(odbc_fetch_row($answer_result)) {
echo "Netscape 4x and ie get here,(display this message)but netscape 6.2 does not”;
…more code that does not execute for netscape 6.2
}
echo “outside while loop all browsers work the same”;
For some reason Netscape 6.2 is returning no rows to the line
while(odbc_fetch_row($answer_result))
even though there are rows returned with every other browser.
Has anyone ever heard of a problem like this?
Thanks in advance for your time,
Seth White
Email: sethwhite@alumni.indiana.edu