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);

but when I directly use the $email in sql, without OCIBindByName, like the
following, it give me result 5, it is correct.

$sql="Select count(*) From member where email='$email'";
$sth=OCIParse($dbh,$sql);
OCIExecute($sth);
OCIFetchInto($sth,$data);

email is char(64) in database.

where is the problem?

Thanks in advance.

Regards;
Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to