PHP loop dropping rec in Oracle.

Anon

Any reason why this code would loop all the results fine except the very first record?

<option value=\"\"> -- Select a Num -- </option>";
while (OCIFetch($sql_statement)) {
$sdf = 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?

Anon

heh.. $sdf should be $num, of course...

Anon

How about posting the code which appears before this code snippet?

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

Anon

The only other code worth mentioning is the SQL itself which snags the data...

$sql = "SELECT name, num FROM table WHERE name = '$name' and rownum >= '0' order by name, num ASC";

// create connection
$connection = OCILogon("user","pass","server")
or die("Couldn't logon.");

// parse SQL statement
$sql_statement = OCIParse($connection,$sql)
or die("Couldn't parse statement.");

// execute SQL query
OCIExecute($sql_statement)
or die("Couldn't execute statement.");

if (!$sql_statement) {  
	echo "<P>Couldn't get num!!";