|
|
Posted by Curt Zirzow on 06/15/08 11:36
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
Navigation:
[Reply to this message]
|