UBB.Developers Forums Community Development Programming PHP and Server-side Scripting SQL in Perl

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.

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.

THANK YOU! You are a god. Exactly what I was looking for!