Re: mysqli bind_param and store_result don't work well together
| From: | Curt Zirzow | Date: | Thu, 05 Jan 2006 07:00:08 +0000 |
| Subject: | Re: mysqli bind_param and store_result don't work well together | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-228192@lists.php.net to get a copy of this message | ||
On Wed, Jan 04, 2006 at 12:31:02AM +0530, anirudh dutt wrote:
> hi
> the subject is pretty much what the problem is.
>
> if i use
> $st1 = $sql->stmt_init(); // $sql is a mysqli obj/conn
> $st1->prepare("select
num from
> activity where id = ?");
> $st1->bind_param('s', $myid);
> $myid = '3f6d017d3e728b057bcc082a7db75a57'; // forcing value to check
...
>
> gives rows: 0, num: 0
...
>
> also, if i use an sql var in the prepare/bind case as
> $st1->prepare("select @ck_num:=num from
> activity where id = ?");
> var_dump($rz) is NULL; otherwise it's int(7)
What version of php and mysql do you have?
Curt.
--
cat .signature: No such file or directory