Stuck with form validation

[David Silva]

Hi everyone,

I have a form with username and password, and when the user enter the right
user and pass he/she go to other page. (that is my thought)

What i did?

    my $dbcon= DBI->connect("dbi:mysql:dbname=dbcontactos","root","");
    my $sql = $dbcon->prepare("select name,pass from Utilizador where
name='?' and pass='?'");
        $sql->execute($user,$pass);
    if($sql == 1){
redirect to other page
    }
    if($sql == 0){
stay in the login page
    }

My problem is that i can't see any other way to do this and even if the
values are correct with the ones in database it stays in the login page.

How can i do this?

Thank you
-- 
David Silva