Oracle database search scripts

[Elknox]

I am using an oracle 8 database backend and I am in urgent need of 2 scripts.

1. A search script that takes two conditions on from a text box and the second from a dropdown menu. The results of the search should also be hyperlinked to give more details from a brief listing.

2. A script that displays an aplhabetic listing of the contents of a field within the database.

[victordb]

I can't remember what Oracle commands look like in PHP if you could send me a basic command the equivilent of a mysql_query I may be able to help you.

[Elknox]

Here is the code for both MySQl and Oracle:

MySQL uses
$result = mysql_query("SELECT my_col FROM my_tbl")
or die ("Invalid query");

Oracle uses
$query = "SELECT my_col FROM my_tbl";
$result = ora_parse($cursor,$query) || die;