ODBC Connectivity

[Anon]

friends,
i am working with php and oracle as backend. now i am facing a problem in data accessing from database. i use distinct clause to select unique value from database but it's not working properly,

here is the code i have return for it

<?
$connection = odbc_connect("test","wap","wap");
$sql_result = odbc_do($connection,"select distinct(name) from testbhavin");
while(odbc_fetch_row($sql_result)){
$name = odbc_result($sql_result,1);
echo $name;
}
odbc_close($connection);
?>

at the time of execution it gives me cursor type error what will be the possible solution for it?

[Anon]

$sql_result = odbc_do($connection,"select distinct(name) from testbhavin");

Not sure if this also goes for Oracle, but perhaps putting a ";" behind testbhavin so:

...from testbhavin;");

Also I used odbc_exec instead of odbc_do..