Greetings ladies and germs! I have run into what is probably a really easy problem to fix.
Being of sound mind, I have been a dedicated php+mysql user for the past 2 years.... but now I have been tasked with not only connecting to a remote oracle database, but also with building a web interface to a specific table.
I got the remote connection issues all sorted out, but now I'm stumped with a looped results issue.
Here's my snippet of the day:
while (OCIFetch($sql_statement)) {
$titan = OCIResult($sql_statement);
echo "
<option value=\"$titan\">$titan</option>
";
}
That's what I understand to be correct, but as you probably know that doesn't work... Ususally in mysql you'd use this format:
while ($row = mysql_fetch_array($sql_result)) {
$titan = $row["TITAN"];
echo "
<option value=\"$titan\">$titan</option>
";
}
See the similarities? It's the OCIResults that throw me...
What am I doing wrong?
