Any reason why this code would loop all the results fine except the very first record?
Begin Code Snippet:
// Grab results from previous selection made, and display the results here
if (OCIFetch($sql_statement)) {
$fname = OCIResult($sql_statement, FNAME);
echo "
<FORM method=\"POST\" action=\"next.php\">
<input type=\"hidden\" name=\"fname\" value=\"$fname\">
<table cellspacing=5 cellpadding=5>
<tr>
<td valign=top><strong>Name:</strong></td>
<td valign=top>
$fname
</td>
</tr>";
}
// Start the looping process for the number drop down menu
echo "
<tr>
<td valign=top><strong>Number:</strong></td>
<td valign=top>
<select name=\"sel_record2\">
<option value=\"\"> -- Select an Number -- </option>";
while (OCIFetch($sql_statement)) {
$num = OCIResult($sql_statement, NUM);
echo "<option value=\"$num\">$num</option>
";
}
The results I should see range from 0001 to 9999, but it skips 0001 and shows everything from 0002 and up... anyone know why?
And how many php developers out there actually USE Oracle? It seems the support for Oracle+PHP is severely limited and usually not very friendly..
