Group E-mail

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
laknal
Forum Newbie
Posts: 21
Joined: Wed Oct 11, 2006 7:38 pm

Group E-mail

Post by laknal »

Hi,

I have to send group emails based on the category selected by user in a product request form. Currently I have emp table with associated role and email.

Do I need to add category table also?


Thanks.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

I don't understand, do you have the product category stored somewhere?
laknal
Forum Newbie
Posts: 21
Joined: Wed Oct 11, 2006 7:38 pm

Group E-mail

Post by laknal »

Hi,

I don't have category table. But the requirement is to send email notification to recipients upon product selection by user.

For example:

User can order product no:1 and 2.

Upon ordering product no:1, I have to send notification to employees in product no:1 section.

Thanks.
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

if your database is normalized, you should have a separate table that links people to their product. You can then select off of that table where the product is the one that is purchased.
Post Reply