Apache and database driven url rewriting

[Mike Cunningham <mike.cunningham@xxxxxxx>]

I have been searching for articles on this and can't find anything for apache that would do want I want but can find some for IIS. What I would like to do is do a url rewrite that would change xxx.pct.edu to www.pct.edu/schools/'schoolname'/xxx.html<http://www.pct.edu/schools/'schoolname'/xxx.html>  where xxx is a code for a major we offer and 'schoolname' is the name of the school that offers that major. Majors come and go and we have a database with our current majors.  So the rewrite would lookup the xxx in a table where I would get the school or even the full url for that major. Has anyone ever een anything like this for Apache or is there a case where writing my own module would required?