in reply to Fetchrow_array returns empty value

We really need to see the contents of $query.

Replies are listed 'Best First'.
Re^2: Fetchrow_array returns empty value
by Anonymous Monk on Mar 24, 2014 at 14:40 UTC
    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";

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

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