note
rodry
It may be a problem with the way DBI handles the query. I swear the thing works fine until I start adding more fields to the loop that store the query's results<p>
Anyways, I stayed up all night trying to figure it out. I even re-wrote the entire script. It worked fine until, as I mentioned, started adding more fields to that loop.
<code>
my $username = param("username");
my $password = param("password");
my $user2;
my $pass2;
my $name;
my $client;
&Create_DB_Connection;
$SQL = "SELECT name, clientid, login, password FROM Client WHERE login='$username' AND password='$password'";
&Do_SQL;
while ($pointer = $sth->fetchrow_hashref)
{
$user2 = $pointer->{'Login'};
$pass2 = $pointer->{'Password'};
$name = $pointer->{'name'};
$client = $pointer->{'ClientID'};
}
</code>
If I try to print out, say, $user2, it will give me a <code>USE OF UNITIALIZED VARIABLE</code> and it won't display the result. Therefore, I suspect the query is not executing for some odd reason. Also checked the case sensitivity of the tables heads. Please help.
7803
7803