mySQL authentication

I have been keeping all user info (including userID and password). in mySQL database. I am launching a new page which will require users to log in before allowing them to do anything.

What is the best way to go about this? Do I need to select all registered userID and password out and make it in a .htpasswd-formatted (with delimiter) and use apache authentication, OR is there a way to authenticate by checking right into the database??

Thanksss!!!

You just have to re-compile Apache with mod_auth_mysql
(http://bourbon.netvision.net.il/mysql/mod_auth_mysql/)
... it worked for me !