On 1/5/06, Curt Zirzow <czirzow@xxxxxxxxx> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
