in reply to Re: Fetchrow_array returns empty value
in thread Fetchrow_array returns empty value

my $query ="select tp.user_type, nm.user_num 
from users us
inner join nums nm on nm.user_num=us.user_num
inner join type tp on us.user_type=tp.user_type
where nm.user_id =:user_id
and nm.num=:num";

[download]

Replies are listed 'Best First'.
Re^3: Fetchrow_array returns empty value
by GotToBTru (Prior) on Mar 24, 2014 at 14:43 UTC

    Your parameter binding has :user. Your query has :user_id.

[reply]
      Yes your right. I have replaced that, but I still have the same problem.
[reply]

In Section Seekers of Perl Wisdom