URL redirect and row-count

[Imtiaz ahmad]

Hi-

Can somebody help me with a function that redirects a user's browser to a
different site.
I like to be able to do it using some PERL function.

Also, is there a function in PERL that tells you how many rows are returned
by a select statement.
e.g. If I have following select then what do I need to do find the total
rows that resulted from the query:

Don't want to use any counter for the LOOP.

-----------------------------------------------------------------
###Select statement to pull all the advertisers
my $check_login="SELECT         users.fullname, security.secname
                FROM    users, security
                WHERE   users.login = '$user_name'
                AND     users.phone = '$password'
                AND     users.secureid = security.secureid";

$dataObject = $dbh->prepare($check_login);
    $dataObject->execute();


while(($fullname, $secname)=$dataObject->fetchrow_array())
        { #start of WHILE loop
print " <TR>
        <TD>$fullname </TD>
        <TD>$secname</TD>
        </TR>
";
        }#close WHILE loop

-----------------------------------------------------------------

thanks.

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]