there is something wrong with ocifetch() statement, when i run the script, i get the error "Could not count rows", would someone check it... thanx
//Create SQL Statement
$sql = "SELECT FIRST_NAME FROM customer WHERE MAIN_USER_NAME='$username' and MAIN_PASSWORD='$password'"
or die ("Could not execute sql statement");
//Parse SQL statement
$statement = ociparse($connection, $sql)
or die ("Could not parse sql statement");
//Execute sql query
Ociexecute($statement)
or die ("could not execute");
//get number of rows, if 0 then false, if 1, then execute
$count = OCIFetch($statement)
or die ("Could not count rows");