Re: Oracle Outer joins supported in PHP4?
| From: | Rasmus Lerdorf | Date: | Wed, 21 Jun 2000 16:23:03 +0000 |
| Subject: | Re: Oracle Outer joins supported in PHP4? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-547@lists.php.net to get a copy of this message | ||
> This SQL statement works fine within the SQL+ environment:
>
> select b.username, fprimer, rprimer, DNA_SOURCE_ID, pcr_name,
> experimental_stage from A, B where fprimer = forward_primer (+) and
> A.set_number = '1'
>
> But in PHP4, when I do a while loop for OCIFetchInto($cursor,
> $values,OCI_ASSOC+OCI_RETURN_NULLS)) no result set comes up.
>
> Any ideas why? I'm stumped.
You are doing something wrong then. PHP has no idea whether you are doing
an outer join or a normal select. PHP doesn't care. Your problem lies
elsewhere.
-Rasmus