phpBB is an extremely popular and well supported web-based forum application.  It is based on PHP and MySQL. A high quality template can make your forum stand out from the crowd.