Posted by anirudh dutt on 01/13/06 23:48

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

• Next in forum: RE: [PHP] Lions and tigers and slashes, oh my!
• Prev in forum: Re: [PHP] Lions and tigers and slashes, oh my!
• Thread view: Re: [PHP] mysqli bind_param and store_result don't work well together

[Reply to this message]