UBB.Dev
Posted By: Greg Hard SQL in Perl - 03/27/2001 4:17 AM
mad
Simply put, I want to be able to call data inside a mysql/mini sql/PosgresSQL database everytime someone logs in.
Basically I want the login to check against a SQL database instead of the flat member files.
So it opens mySQL, matches the info as it would with flatfiles.

I am doing a complete mySQL conversion for UBB and did the threads, images, var files, etc etc. But am finishing member info.
Posted By: Ell Re: SQL in Perl - 03/27/2001 9:21 PM
Might be worth looking into Leshracs profile hash thing too...

$cursor = $dbh->prepare("SELECT username, password, email, posts, etc FROM members WHERE usernumber='$number'");
$cursor->execute;

then fetch the items, ir returns, or do a fetchrow_array if you're fetching by something other than usernumber, and expect multiple results.

usernumber should probably be the primary key in that database table.
Posted By: Greg Hard Re: SQL in Perl - 03/27/2001 9:32 PM
THANK YOU! You are a god. Exactly what I was looking for!
© UBB.Developers