I have a php page which connect to oracle table, there is one data need to pull out from oracle, if not exist then I want to leave it blank.
But when I write the code:
If $abc exists in table, it has no problem to pull the data, if $abc doesn't exist, then it shows all error message on php page.(Warning: Ora_Fetch failed (ORA-01002: fetch out of sequence -- while processing OCI function OFETCH/OFEN) in .....)
How can I get rid of these error message?
thanks.
But when I write the code:
Code:
$query = "select name from table where field1='$abc'";
ora_parse($cursor, $query);
ora_exec($cursor);
If $abc exists in table, it has no problem to pull the data, if $abc doesn't exist, then it shows all error message on php page.(Warning: Ora_Fetch failed (ORA-01002: fetch out of sequence -- while processing OCI function OFETCH/OFEN) in .....)
How can I get rid of these error message?
thanks.