[RatherSurf]

I am new here. I have been searching the net for the last couple of days and cant find anything. In php and mysql I can create a drop down list fine. I am having a problem creating a drop down list in php using sql pulling from and oracle db. Can anyone help or tell me where to look....

Thanks in advance,

[wizkid]

try at php.net.. you might find there what you need:
http://www.php.net/manual/en/ref.oracle.php

[RatherSurf]

Just in case it helps anyone out I have the code that works now.

<form method="GET" action="test.php">
<select name="school_name">
<?
// Connect to DB
$conn = ociLogon("name", "name", "name");

// This is the SQL statement to run
$query = "SELECT * FROM schools order by Name";

// This parses the SQL Statement for use
$statement = OCIParse($conn, $query);

// OCIExecute returns true/false if the query succedded in runnin
// Note that this does *NOT COMMIT* by default, if you are using INSERT/UPDATE/DELETE
if(OCIExecute($statement))
{
// oci_fetch_array() returns the next row from the result set, OCI_BOTH returns tuples as both associative array
// eg, '$row['NAME']' and indexed array, eg $row[1].
// You can also use oci_fetch_assoc() for just an associative array, or oci_fetch_row() for just numeric array
// Oracle returns all field names in UPPERCASE, so your associative array's will be indexed as such as well.

while(OCIFetchInto($statement, $row, OCI_ASSOC))
{
printf("<option value='%s'>%s</option>\n", htmlentities($row['NAME']), htmlentities($row['NAME']));
}
}
?>
</select>
<input type="submit" />
</form>

<?
if($_GET['school_name']){

print "SELECTED SCHOOL WAS: ";
print $_GET['school_name'];
}
?>