Re: mysqli bind_param and store_result don't work well together
| From: | anirudh dutt | Date: | Fri, 13 Jan 2006 21:48:55 +0000 |
| Subject: | Re: mysqli bind_param and store_result don't work well together | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-228590@lists.php.net to get a copy of this message | ||
On 1/5/06, Curt Zirzow <czirzow@gmail.com> wrote:
> 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.
php 5.0.3
mysql 4.1.14-nt
Apache/2.0.50 (Win32)
anirudh