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