I have a table (employees) like this

ID Name Group Email

1          Bob Buckland       Marketing     b@example.com

2          George Alaz     Engineering   g@example.com

3          Tom Grady       Marketing     t@example.com

4          Mary Jane       Engineering   m@example.com

Im going to use this in a email form. First a combobox should load all the groups possible. This means it should load 2 groups, Marketing and Engineering

Groups is easy I believe:

select distinct Group from employees;

After selecting that, I should load all the names that are in that group.

Im not sure how to do names:

select Name from employees where=?

The "where" condition is what Im not sure about.

And after, how do I get the email I selected?

Thanks

SELECT name, email FROM employees WHERE group = '<your_selected_group>'
commented: Good starting point +7

select distinct Group from employees;

Result:
Marketing*
Engineering

select Name from employees where Group='Marketing'

Result:
Bob Buckland
Tom Grady*

select Email from employees where Group='Marketing' and Name='Tom Grady'

Result:
t@example.com

OK got it. Sorry, it was a simply query but It wasnt coming to my head.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.