Re: question about OCIBindByName(add some comment)
| From: | Thies C. Arntzen | Date: | Mon, 21 May 2001 14:39:05 +0000 |
| Subject: | Re: question about OCIBindByName(add some comment) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9502@lists.php.net to get a copy of this message | ||
On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote:
> Hi;
> Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.
>
> I use the following lines to get a result from database;
> But It give me result 0, it is incorrect;
>
> $sql="Select count(*) From member where email=:email";
> $sth=OCIParse($dbh,$sql);
> OCIBindByName($sth,"email",$email,64);
> // with or without ':' is same, and use reference or not is also same here.
> OCIExecute($sth);
> OCIFetchInto($sth,$data);
have you set $email in your script (before OCIExecute)?
tc