Database and form software or script needed

[webdev]

I am looking for soaftware or a sript that I can build a site around or add to an exsisting site that is partially driven by a user database with assignable previlidges. I am also looking to do promotions that I would need mutliple forms for and surveys. It needs to also including automatic email...